N918AN
Service difficulty reports · 165
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N918AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N918AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA20100120TUL05Oxygen Mask · failedOXYGEN MASKS INADVERTENTLY DROPPED WHILE AT GATE. OXYGEN MASKS AT SEAT ROWS 8DEF, 14DEF, 16ABC, 20DEF, 23DEF AND 27ABC FAILED TO DEPLOY. REPLACED OXYGEN MASKS.SDR AALA2009082100002Battery Pack · dischargedMIA - OVERHEAD BIN EMERGENCY LIGHT ROW 15ABC TO 21ABC FAILED. REPLACED BATTERY PACK FOR OVERHEAD BIN EMERGENCY LIGHT ROW 15ABC TO 21ABC.SDR AALA2009082100001Battery Pack · dischargedMIA - LEFT NUMBER ONE DOOR EMERGENCY LIGHT FAILED. REPLACED BATTERY PACK FOR LEFT NUMBER ONE DOOR EMERGENCY LIGHT.SDR AALA20090731TUL05Stringer · crackedTUL - LONGITUDINAL CRACK IN STRINGER 3L. REPAIRED UNDER EA 737-53-006987.SDR AALA20090731TUL04Skin · dentedTUL - CROWN SKIN DENTED AND GOUGED AT STATION 325, STRINGER 3L. REPAIRED UNDER EA 737-53-006987.SDR AALA20090731TUL03Skin · gougedTUL - TWO GOUGES IN FUSELAGE SKIN AT STATION 317, STRINGER 3L. REPAIRED UNDER EA 737-53-006987.SDR AALA2009042200002Hinge · brokenDFW - CREW REPORTED AIRFRAME VIBRATIONS FELT THROUGH THE PEDALS AND THE FLOOR. EMERGENCY DECLARED, RETURNED TO DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND AIR START ACCESS PANEL FORWARD OUTBOARD HINGE BROKEN AND CORNER OF PANEL LOOSE CAUSING SDR AALA2009021101029Pump · inoperativeDFW - DECLARED EMERGENCY ON DESCENT ON ACCOUNT OF RIGHT ENGINE LOW PRESSURE LIGHT ILLUMINATED. IN FLIGHT LEFT ENGINE HYDRAULIC LOW PRESSURE LIGHT FLICKERED ON AND OFF SEVERAL TIMES IN CRUISE. LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLSDR AALA200803188Control Valve · failedDFW - BLEED TRIP LIGHT ILLUMINATED AT FLIGHT LEVEL 380. DIVERTED TO DFW TO AVOID ICING CONDITIONS. LANDED WITHOUT INCIDENT. REPLACED PRECOOLER CONTROL VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800377Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT FORWARD LEFT EXTERIOR OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD LEFT HAND EXTERIOR OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800379Sign · missingDFW - OVERHEAD EMERGENCY EXIT SIGN LIGHT AT OVERWING EXIT IS MISSING. REPLACED CEILING PANEL WITH EMERGENCY EXIT SIGN FOR EMERGENCY LIGHT AT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800326Flashlight · inoperativeLGA - EMERGENCY FLASHLIGHT AT AFT RIGHT FLIGHT ATTENDANT JUMPSEAT INOPERATIVE. REPLACED EMERGENCY FLASHLIGHT AT AFT RIGHT FLIGHT ATTENDANT JUMPSEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040868Cable · brokenIAH - INFLIGHT T1068/17 AFTER TAKEOFF THE LANDING GEAR HANDLE COULD NOT BE RAISED. WHEN FLAPS WERE RAISED TO ZERO DEGREES THE CONFIGURATION WARNING HORN SOUNDED. RETURNED TO IAH AND LANDED WITHOUT INCIDENT. FOUND RIGHT HAND AIR TO GROUND SENSE CABLE BROKEN SDR AALA20040712Light · inoperativeBOS - EMERGENCY LIGHT AT L1 DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY AT L1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040417Light · brokenORD - WALL MOUNTED EMERGENCY EXIT LIGHT FIXTURE AT SEAT 14A BROKEN. REPLACED WALL MOUNTED EMERGENCY EXIT LIGHT FIXTURE AT SEAT 14A. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N918AN