N789AN
Service difficulty reports · 262
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 = 'N789AN' 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 = 'N789AN' 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 AALA20100826DFW04Light · inoperativeSEAT 38C ESCAPE PATH LIGHT HAS 1 LAMP INOPERATIVE. REPLACED LAMP AT SEAT 38C FOR ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100826DFW03Cover · missingEXIT SIGN WIRES EXPOSED AT ROW 30C. INSTALLED NEW COVER FOR EXIT SIGN AT ROW 30C. OPS CHECKED NORMAL.SDR AALA20100826DFW02Light · inoperativeSEAT 36C ESCAPE PATH LIGHT HAS 1 LAMP INOPERATIVE. REPLACED LAMP FOR SEAT 36C ESCAPE PATH LIGHT. OP CHECKED NORMAL.SDR AALA20100826DFW01Light · inoperativeSEAT 35C ESCAPE PATH LIGHT HAS 1 LAMP INOPERATIVE. REPLACED LAMP FOR SEAT 35C ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100721DFW01Lens · missingESCAPE PATH LIGHT AT SEAT 34G IS MISSING LENS. REPLACED LENS AT SEAT 34G FOR ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100629MIA03Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 36 INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT ROW 36. OPS CHECKED NORMAL.SDR AALA20100629MIA02Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 29 INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT ROW 29. OPS CHECKED NORMAL.SDR AALA20100629MIA01Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 14 INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT ROW 14. OPS CHECKED NORMAL.SDR AALA20100410NRT01Coffeemaker · malfunctionedNRT - FLIGHT ATTENDANT REPORTED ODOR AROUND COFFEEMAKERS 7 AND 8 AND SAW WHAT APPEARED TO BE SMALL AMOUNT OF SMOKE. CIRCUIT BREAKERS PULLED. SMELL SLOWLY DISCIPATE. TURNED OFF INFLIGHT ENTERTAINMENT AND SMELL COMPLETELY DISCIPATED. FLIGHT LANDED NRT WITHOSDR AALA20100117DFW07Lens · missingOVERHEAD EMERGENCY LIGHT LENS COVER IS MISSING AT ROW 9 RIGHT. REPLACED LENS COVER.SDR AALA20091103NRT01Light · brokenEMERGENCY LIGHT AT FIRST CLASS COAT CLOSET BROKEN. REPLACED LIGHT ASSEMBLY.SDR AALA20090918MIA09Light · inoperativeEMERGENCY LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMP AT 33G, OPS CHECK NORMAL.SDR AALA20090918MIA08Light · inoperativeEMERGENCY LIGHT AT SEAT 38C INOPERATIVE. REPLACED LAMP AT 38C, OPS CHECK NORMAL.SDR AALA20090918MIA07Light · inoperativeEMERGENCY LIGHT AT SEAT 34C INOPERATIVE. REPLACED LAMP AT 34C, OPS CHECK NORMAL.SDR AALA20090918MIA06Lens · missingEMERGENCY LIGHT SWITCH AT SEAT 31G MISSING PROTECTIVE LIGHT COVER. REPLACED LIGHT COVER AT 31G, OPS CHECK NORMAL.SDR AALA20090918MIA05Light · inoperativeEMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP AT 31G, OPS CHECK NORMAL.SDR AALA20090918MIA04Light · inoperativeEMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP AT SEAT 32C, OPS CHECKS NORMAL.SDR AALA2009041700779Lamp · burned outDFW - OVERHEAD EMERGENCY PATH LIGHTING AT ROW 2G INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMERGENCY PATH LIGHTING AT ROW 2G.SDR AALA200801968Lens · missingDFW EMERGENCY LIGHT AT SEAT 31G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801969Lamp · inoperativeDFW EMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801387Lens · missingDFW - EMERGENCY LIGHT AT SEAT ROW 11D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 11D. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801375Battery Pack · inoperativeLAX - EMERGENCY LIGHTS AT CENTER AFT FOUR SEAT ROWS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT CENTER AFT FOUR SEAT ROWS. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801374Connector · looseLAX - EMERGENCY LIGHTS AT CENTER AFT FOUR SEAT ROWS INOPERATIVE. RESEATED CONNECTOR AT SEAT ROW 42CD. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800791Light · inoperativeJFK - EMERGENCY LIGHT AT FORWARD GALLEY INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800451Lens · missingDFW - EMERGENCY LIGHT AT SEAT 38G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 38G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072387Lens · missingMIA - EMERGENCY LIGHT AT SEAT 24G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072341Lens · missingJFK - EMERGENCY LIGHT AT SEAT 38G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 38G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072346Lamp · missingJFK - EMERGENCY LIGHT AT SEAT 26C MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072345Lens · missingJFK - EMERGENCY LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072344Lamp · missingJFK - EMERGENCY LIGHT AT SEAT 25C MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072347Lens · missingJFK - EMERGENCY LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072343Battery Pack · inoperativeJFK - SEAT MOUNTED EMERGENCY LIGHTS AT FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK M33094 FOR SEAT MOUNTED EMERGENCY LIGHTS AT FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072342Lens · missingJFK - EMERGENCY LIGHT AT SEAT 21G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071525Bulb · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 23G INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT ROW 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071524Bulb · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 24G HAS MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 24G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071521Bulb · missingDFW - EMERGENCY LIGHT AT SEAT ROW 37C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 37C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071520Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 36C INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 36C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071519Bulb · missingDFW - EMERGENCY LIGHT AT SEAT ROW 20C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071523Bulb · missingDFW - EMERGENCY LIGHT AT SEAT ROW 36G HAS MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 36G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071522Lens · missingDFW - EMERGENCY LIGHT AT SEAT ROW 36G HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 36G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071526Bulb · missingDFW - EMERGENCY LIGHT AT SEAT ROW 21G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071327Bulb · inoperativeDFW - EMERGENCY EXIT LIGHT AT MID GALLEY LEFT AISLE INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT MID GALLEY LEFT AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071328Bulb · inoperativeDFW - EMERGENCY EXIT LIGHT AT SEAT ROW 21C INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT SEAT ROW 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071299Windshield · arcedBOS INFLIGHT T174/13JUL RDU TO LGW - FIRST OFFICERS WINDSHIELD CRACKED AND ARCING. HEAT TURNED OFF AND LANDED BOS WITHOUT INCIDENT. REPLACED FIRST OFFICERS WINDSHIELD IN ACCORDANCE WITH MAINTENANCE MANUAL 56 11 01 4. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071232Lens · missingJFK - EMERGENCY LIGHT AT SEAT 36C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20071231Bulb · inoperativeJFK - EMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED BULB FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071230Lens · missingJFK - EMERGENCY LIGHT AT SEAT 21C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071229Bulb · inoperativeJFK - EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071011Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 25G INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 25G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071013Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N789AN