N791AN
Service difficulty reports · 325
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 = 'N791AN' 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 = 'N791AN' 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 AALA20100126MIA04Lens · missingSEAT 45G EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS AT SEAT 45G.SDR AALA20100126MIA03Lens · missingEMERGENCY LIGHT AT SEAT 36C MISSING LENS. REPLACED LENS AT SEAT 36C.SDR AALA20100126MIA02Lens · missingEMERGENCY LIGHT AT SEAT 30C MISSING LENS. REPLACED LENS AT SEAT 30C.SDR AALA20100126MIA01Light · inoperativeOVERHEAD EMERGENCY LIGHT FORWARD GALLEY RIGHT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20091224MIA10Oxygen Bottle · low pressureCREW OXYGEN BOTTLE BELOW MINIMUMS. REPLACED OXYGEN BOTTLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091224MIA09Light · inoperativeEXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20091224MIA08Lens · missingEMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR AFT MISSING LENS. REPLACED LENS.SDR AALA20091224MIA07Lens · missingEMERGENCY LIGHT AT SEAT 21C MISSING LENS. REPLACED LENS.SDR AALA20091224MIA06Lens · missingEMERGENCY LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS.SDR AALA20091224MIA05Light · looseEMERGENCY LIGHT AT SEAT 15C LOOSE. SECURED LAMP.SDR AALA20091224MIA04Light · inoperativeEMERGENCY LIGHT AT OVERHEAD SEAT 9G INOPERATIVE. REPLACED LAMP.SDR AALA20091224MIA03Light · inoperativeEMERGENCY LIGHT AT SEAT 2G INOPERATIVE. REPLACED LAMP.SDR AALA20091224MIA02Light · inoperativeEMERGENCY LIGHT AT LEFT FORWARD GALLEY INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR AALA20091224MIA01Light · inoperativeFORWARD LEFT NUMBER ONE ENTRY DOOR EMERGENCY LIGHT INOPERATIVE OVERHEAD. REPLACED LAMP AT OVERHEAD LEFT NUMBER ONE DOOR.SDR AALA2009062300001Light · not seatedNRT - EMERGENCY PATH LIGHT AT FORWARD EDGE FIRST CLASS CLOSET NEEDS RE-INSTALLED. RESEATED LIGHT ASSEMBLY AT FORWARD EDGE FIRST CLASS CLOSET.SDR AALA2009050500002Warning Message · false activationLHR EMERGENCY LIGHT IS ANNUCIATED ON UPPER EICAS. LANDED LHR WITHOUT INCIDENT. NO MESSAGE CYCLED CIRCUIT BREAKER EICAS MESSAGE CLEARED. SYSTEM GROUND CHECK NORMAL OPERATION. (CLOSED)SDR AALA2009031900615Lens · missingDFW EMERGENCY LIGHT AT SEAT 36C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 36C.SDR AALA2009031900614Light · missingDFW EMERGENCY LIGHT AT SEAT 36C MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 36C.SDR AALA2009031900613Power Supply · dischargedDFW EMERGENCY LIGHT IN CENTER AISLE FROM SEAT 30 TO SEAT 45 INOPERATIVE. REPLACED POWER SUPPLY FOR EMERGENCY PATH LIGHTING AT RIGHT NUMBER 3 DOOR.SDR AALA2009031200581Lens · missingDFW EMERGENCY LIGHT LENS AT SEAT 35G MISSING. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 35G.SDR AALA2009031200580Lamp · burned outDFW - EMERGENCY LIGHT AT SEAT 35G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 35G.SDR AALA2009031100582Battery Pack · dischargedDFW INTERIOR RIGHT NUMBER 4 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT INTERIOR RIGHT NUMBER 4 DOOR.SDR AALA2009031100579Lens · missingDFW - EMERGENCY LIGHT AT SEAT 33G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 33G.SDR AALA2009031100578Lamp · burned outDFW - EMERGENCY LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 33G.SDR AALA200803059Lens · missingDFW - EMERGENCY LIGHT AT SEAT 31G HAS MISSING LENS. REPLACED LENS AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803058Lens · missingDFW - EMERGENCY LIGHT AT SEAT 37C HAS MISSING LENS. REPLACED LENS AT SEAT 37C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803057Lens · missingDFW - EMERGENCY LIGHT AT SEAT 35C HAS MISSING LENS. REPLACED LENS AT SEAT 35C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803056Light · inoperativeDFW EMERGENCY LIGHT AT SEAT 30C INOPERATIVE. REPLACED LAMP AT SEAT 30C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802009Lamp · inoperativeJFK EMERGENCY LIGHT AT SEAT 25G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25G. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801400Wire · looseDFW - EMERGENCY LIGHT WIRING AT RT NR ONE DOOR GALLEY EXPOSED. SECURED WIRING FOR EMERGENCY LIGHT AT RT NR ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801399Housing · damagedDFW - EMERGENCY LIGHT AT LT NR ONE DOOR DAMAGED. REPLACED LIGHT HOUSING FOR EMERGENCY LIGHT AT LT NR ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801398Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 30 TO 45 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 30 TO 45. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801397Wire · looseDFW - EMERGENCY LIGHT WIRING AT MAIN DECK CREW REST FORWARD CLOSET EXPOSED. SECURED WIRING FOR EMERGENCY LIGHT AT MAIN DECK CREW REST FORWARD CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801396Lamp · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT LEFT NR FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT LEFT NR FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801395Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801177Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 25G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800623Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 44C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 44C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800629Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 20G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 20G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800622Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800627Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800626Light · inoperativeDFW - EMERGENCY LIGHT AT L1 DOOR STOWAGE COMPARTMENT IS DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT L1 DOOR STOWAGE COMPARTMENT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800625Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800624Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800628Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800409Lens · missingNRT - EMERGENCY EXIT LIGHT AT SEAT 21G MISSING LENS. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072025Lamp · inoperativeORD - EMERGENCY LIGHT AT SEAT ROW 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072026Lens · missingORD - EMERGENCY LIGHT AT SEAT ROW 22C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071659Bulb · inoperativeORD - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070902Battery Pack · inoperativeJFK - SEAT MOUNTED EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHT AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070743Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N791AN