Baselight
Sign In

Aircraft Historical Maintenance Dataset(2012-2017)

Problem and Action taken in aircraft maintenance logs for NLP

@kaggle.merishnasuwal_aircraft_historical_maintenance_dataset

Aircraft Annotation Datafile
@kaggle.merishnasuwal_aircraft_historical_maintenance_dataset.aircraft_annotation_datafile

  • 175.86 KB
  • 6169 rows
  • 3 columns
ident

IDENT

problem

PROBLEM

action

ACTION

100001ENGINE IDLE OVERRIDE KILLED ENGINE.TRIED TO ADJUST IDLE SEVERAL TIMES, WOULDN'T ADJUST.
100002ENGINE IDLE OVERRIDE KILLED ENGINE.REMOVED & REPLACED FUEL SERVO
100003ENGINE IDLE OVERRIDE KILLED ENGINE.A/C WAS RUN UP, SET IDLE SPEED, MIXTURE OK, NO LEAKS NO
100004HAD ENGINE CHOKE & BRIEFLY LOSE POWER ON DEPARTURE. FULL THRPERFORMED ENGINE RUN UP, FOUND CYL 2 LOWER PLUG FOULED.
100005#2 & 4 CYL ROCKER COVER GASKETS ARE LEAKING.REMOVED & REPLACED GASKETS.
100006ROCKER BOX COVER SCREWS LOOSE (ALL CYL).TIGHTENED SCREWS.
100007INDUCTION TUBE HOSE CLAMPS LOOSE (ALL CYL).TIGHTENED HOSE CLAMPS.
100008#3 INTAKE IS LEAKING.REMOVED & REPLACED GASKET.
100009#2 INTAKE IS LEAKING.REMOVED & REPLACED #2 INTAKE GASKET.
100010#4 ROCKER COVER IS LEAKING.REMOVED & REPLACED #4 ROCKER COVER GASKET.

CREATE TABLE aircraft_annotation_datafile (
  "ident" BIGINT,
  "problem" VARCHAR,
  "action" VARCHAR
);