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 AALA20111110TUL07Lens · missingSEAT 40G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111110TUL06Light · inoperativeSEAT 22G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 22G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111110TUL05Light · inoperativeCEILING EMERGENCY LIGHT AT 27J INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT 27J. OPS CHECK NORMAL.SDR AALA20111110TUL04Light · inoperativeCEILING EMERGENCY LIGHT AT 27H INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT 27H. OPS CHECK NORMAL.SDR AALA20111110DFW03Light · inoperativeRIGHT NUMBER 1 DOOR INTERNAL OVERHEAD ESCAPE PATH LIGHT IS INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 DOOR INTERNAL OVERHEAD ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111110DFW02Light · inoperativeSEAT 23G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111110DFW01Light · missingSEAT 25D ESCAPE PATH LIGHT LAMPS MISSING. REPLACED LAMPS FOR SEAT 25D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111028JFK02Connector · looseEMERGENCY LIGHTS AT 42G THROUGH 45G INOPERATIVE. SECURED LOOSE CONNECTOR AT SEAT 41G. OPS CHECK NORMAL.SDR AALA20111028JFK01Connector · looseEMERGENCY LIGHTS AT 42C THROUGH 45C INOPERATIVE. SECURED LOOSE CONNECTOR AT SEAT 41C. OPS CHECK NORMAL.SDR AALA20110415DFW06Battery Pack · dischargedRIGHT NUMBER 1 DOOR EXIT IDENTIFIERS INOPERATIVE. REPLACED BATTERY PACK M33094. OPS CHECK NORMAL.SDR AALA20110415DFW05Light · brokenFIRST CLASS GALLEY CLOSET FORWARD EMERGENCY LIGHT IS BROKEN. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS GALLEY CLOSET FORWARD EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110415TUL05Lens · missingSEAT 38C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 38C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110415DFW04Light · inoperativeSEAT 38C EMERGENCY LIGHT IS INOPERATIVE. REPLACED LAMP FOR SEAT 38C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110415DFW03Light · inoperativeSEAT 34C EMERGENCY LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR SEAT 34C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110415DFW02Light · inoperativeSEAT 32C EMERGENCY LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR SEAT 32C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110415DFW01Light · inoperativeLEFT NUMBER 2 DOOR AFT EXIT IDENTIFIER HAS LAMPS INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR AFT EXIT IDENTIFIER. OPS CHECK NORMAL.SDR AALA20101223TUL05Lens · damagedESCAPE PATH LIGHT AT ROW 29G HAS DAMAGED LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 29G. OPS CHECK NORMAL.SDR AALA20101223TUL04Light · damagedESCAPE PATH LIGHT AT ROW 29G HAS DAMAGED LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 29G. OPS CHECK NORMAL.SDR AALA20101223TUL03Lens · damagedESCAPE PATH LIGHT AT ROW 45C HAS DAMAGED LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 45C. OPS CHECK NORMAL.SDR AALA20101223TUL02Light · damagedESCAPE PATH LIGHT AT ROW 45C HAS DAMAGED LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 45C. OPS CHECK NORMAL.SDR AALA20101223TUL01Light · damagedESCAPE PATH LIGHT AT ROW 24C HAS DAMAGED LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 24C. OPS CHECK NORMAL.SDR AALA20101222DFW04Lens · damagedESCAPE PATH LIGHT AT ROW 24C HAS DAMAGED LENS. REPLACED LENS FOR ESCAPE PATH LIGHT ST ROW 24C.SDR AALA20100929TUL09Light · inoperativeRIGHT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20100929TUL08Lens · missingSEAT 23C EMERGENCY LIGHT MISSING LENS. REPLACED SEAT 23C EMERGENCY LIGHT LENS. OPS CHECKS NORMAL.SDR AALA20100929MIA05Light · inoperativeCREW REST AREA RIGHT FORWARD EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR CREW REST AREA EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20100929MIA04Wire · damagedFORWARD GALLEY LEFT OUTBOARD CORNER EMERGENCY LIGHT INOPERATIVE. REPAIRED WIRING FOR EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20100929MIA03Light · inoperativeSEAT 23C EMERGENCY LIGHT INOPERATIVE. REPLACED SEAT 23C EMERGENCY LIGHT LAMP. OPS CHECKS NORMAL.SDR AALA20100929MIA02Light · not seatedLEFT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. RE-SEATED LAMP FOR EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20100929MIA01Battery Pack · dischargedSEVERAL AFT GALLEY EMERGENCY LIGHTS LEFT AND RIGHT SIDES INOPERATIVE. REPLACED BATTERY PACK FOR AFFECTED LIGHTS. OPS CHECKED NORMAL.SDR AALA20100905DFW01Cover · missingSEAT 35G ESCAPE PATH LIGHT MISSING COVER. REPLACED COVER FOR ESCAPE PATH LIGHT AT SEAT 35G. OPS CHECKED NORMAL.SDR AALA20100801DFW03Light · inoperativeSEAT 11G AFT ESCAPE PATH LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 11G AFT ESCAPE PATH LIGHT ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20100801DFW02Light · inoperativeSEAT 11G FORWARD ESCAPE PATH LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 11G FORWARD ESCAPE PATH LIGHT ASSEMBLY, OPS CHECKED NORMAL.SDR AALA20100801DFW01Lens · missingESCAPE PATH LIGHT AT SEAT 38C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 38C. OPS CHECKED NORMAL.SDR AALA20100704MIA06Light · inoperativeSEAT 26G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26G. OPS CHECKED NORMAL.SDR AALA20100704MIA05Light · inoperativeSEAT 22C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C, OPS CHECKED NORMAL.SDR AALA20100704MIA04Light · inoperativeSEAT 9D EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 9D. OPS CHECKED NORMAL.SDR AALA20100704MIA03Light · inoperativeRIGHT NUMBER 2 DOOR HAS CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 DOOR CEILING EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100704MIA02Light · inoperativeCEILING EMERGENCY LIGHT AT 1D. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT 1D. OPS CHECKED NORMAL.SDR AALA20100704MIA01Lens · missingEMERGENCY LIGHT AT FORWARD GALLEY COAT CLOSET MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD GALLEY COAT CLOSET. OPS CHECKED NORMAL.SDR AALA20100620DFW02Light · damagedESCAPE PATH LIGHT DAMAGED AT LEFT NUMBER 1 CLOSET DOOR. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHT AT LEFT NUMBER 1 CLOSET DOOR. OPS CHECKED NORMAL.SDR AALA20100805TUL03Lens · missingSEAT 38C ESCAPE PATH LIGHTING MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 38C. OPS CHECKED NORMAL.SDR AALA20100620DFW08Light · missingSEAT 38C ESCAPE PATH LIGHTING MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 38C. OPS CHECKED NORMAL.SDR AALA20100620DFW06Wire · exposedMAIN DECK CREW REST AFT LINEN CLOSET ESCAPE PATH LIGHT WIRES EXPOSED. SECURED MAIN DECK CREW REST AFT LINEN CLOSET ESCAPE PATH LIGHT WIRES. OPS CHECKED NORMAL.SDR AALA20100620DFW09Light · inoperativeSEAT 39C ESCAPE PATH LIGHTING HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR SEAT 39C ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100620DFW07Light · inoperativeROW 30 CENTER LAVATORY OCCUPIED SIGN LAMPS INOPERATIVE. REPLACED LAMP FOR ROW 30 CENTER LAVATORY OCCUPIED SIGN. OPS CHECKED NORMAL.SDR AALA20100512DFW04Light · inoperativeAISLE ESCAPE PATH LIGHT AT SEAT 11D. REPLACED LAMP FOR AISLE ESCAPE PATH LIGHT AT SEAT 11D. OPS CHECKED NORMAL.SDR AALA20100403MIA05Light · brokenESCAPE PATH LIGHT WIRES TO FORWARD LIGHT ASSEMBLY BROKEN ON SIDE PANEL SEAT 11G. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHT AT SEAT 11G. OPS CHECKED NORMAL.SDR AALA20100126MIA07Light · inoperativeEXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER 4 DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20100126MIA06Connector · not seatedEXTERIOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. RESEATED EMERGENCY LIGHT CONNECTOR AT LEFT NUMBER FOUR DOOR.SDR AALA20100126MIA05Light · inoperativeEMERGENCY LIGHT AT AFT OVERHEAD AFT GALLEY INOPERATIVE. REPLACED LAMP.
Back to N791AN