N799AN
Service difficulty reports · 272
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 = 'N799AN' 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 = 'N799AN' 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 AALA20110420TUL10Lens · crackedRIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT LENS CRACKED. REPLACED LENS FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110419DFW05Light · inoperativeRIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110126DFW03Light · inoperativeLEFT NUMBER 2 DOOR SLIDE EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR SLIDE EMERGENCY EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20110126DFW02Lens · missingSEAT 23G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101219DFW12Light · inoperativeRIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20101219DFW11Light · inoperativeLEFT NUMBER 2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR EXTERIOR EMERGENCY EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20101011DFW09Light · inoperativeROW 39G ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ROW 39G ESCAPE PATH LIGHT. OPS CHECKS GOOD.SDR AALA20101011DFW08Lens · missingROW 35G ESCAPE PATH LIGHT HAS LENS MISSING. REPLACED LENS FOR ROW 35G ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101011DFW07Light · inoperativeRIGHT NUMBER 2 DOOR LEFT SIDEWALL ESCAPE PATH LIGHT HAS ONE BULB INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 DOOR LEFT SIDEWALL ESCAPE PATH LIGHT. OPS CHECKS GOOD.SDR AALA20101011DFW06Lens · missingROW 21G ESCAPE PATH LIGHT HAS LENS MISSING. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 21G. OPS CHECKS NORMAL.SDR AALA20101011DFW05Track · defectiveMAIN DECK CREW REST AFT CLOSET ESCAPE PATH LIGHT WIRES EXPOSED. REPLACED RACE TRACK IN MAIN DECK CREW REST AFT CLOSET.SDR AALA20101011DFW04Light · inoperativeLEFT NUMBER 1 DOOR RIGHT SIDEWALL ESCAPE PATH LIGHT LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 1 DOOR RIGHT SIDEWALL EXIT ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101011DFW03Light · inoperativeRIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LGIHT. OPS CHECKS NORMAL.SDR AALA20100728DFW01Light · missingAT 39C MISSING EMERGENCY LIGHT LAMP. REPLACED LAMP FOR 39C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100728DFW03Light · inoperativeRIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100728DFW02Light · inoperativeRIGHT NUMBER 3 DOOR FORWARD EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 3 DOOR FORWARD EXIT LIGHT. OPS CHECKED NORMAL.SDR AALA20100512DFW02Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT 35C INOPERATIVE. REPLACED LAMP FOR SEAT MOUNTED EMERGENCY LIGHT AT 35C. OPS CHECK NORMAL.SDR AALA20100512DFW01Guard · brokenFORWARD FLIGHT ATTENDANT STATION EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. REPLACED GUARD.SDR AALA20100421MIA05Lens · missingEMERGENCY LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 32G. OPS CHECKED NORMAL.SDR AALA20100421MIA04Light · inoperativeEMERGENCY LIGHT AT AFT GALLEY CENTER INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT AFT GALLEY CENTER. OPS CHECKED NORMAL.SDR AALA20100421MIA03Light · inoperativeRIGHT NUMBER 4 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 4 DOOR EMERGENCY EXIT LIGHT. OPS GOOD.SDR AALA20100421MIA02Light · inoperativeSEAT 34C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 34C. OPS CHECKED NORMAL.SDR AALA20100421MIA01Light · inoperativeEMERGENCY EXIT LIGHT AT RIGHT SIDE OF FIRST CLASS GALLEY INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT RIGHT SIDE OF FIRST CLASS GALLEY. OPS CHECKED NORMAL.SDR AALA20091001DFW01Battery Pack · dischargedEMERGENCY LIGHTS IN FIRST CLASS CEILING INOPERATIVE. INSTALLED NEW BATTERY PACK, CHECK GOOD.SDR AALA20090911DFW04Light · damagedEMERGENCY LIGHT ASSEMBLY DAMAGED IN CABIN. REPLACED LIGHT HOUSING ASSEMBLY, OPS CHECKS OK.SDR AALA2009061400008Acm · malfunctionedGRU - FLIGHT EXPERIENCED LOUD HUMMING NOISE AND MID CABIN FILLED WITH HAZE AND STRONG FUMES. FOUND AIR CONDITIONING PACK HAD MALFUNCTIONED. REPLACED RIGHT AIR CYCLE MACHINE ON JUNE 15 AT MIA. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200802243Lens · missingJFK EMERGENCY LIGHT AT SEAT 4D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 4D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802242Battery Pack · dischargedJFK EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 22H TO 27J INOPERATIVE. REPLACED BATTERY PACK AT RT NR 3 DOOR FOR EMERGENCY LIGHTS AT OVERHEAD SEAT ROWS 22H TO 27J. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802162Battery Pack · dischargedJFK EMERGENCY LIGHTS AT LT SEAT ROWS 30 TO AFT CABIN INOPERATIVE. REPLACED BATTERY PACK M33401 FOR EMERGENCY LIGHTS AT LT SEAT ROW 30 TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802161Light · shortedJFK EMERGENCY LIGHTS AT RT SEAT ROWS 30 TO AFT CABIN INOPERATIVE. REPLACED SHORTED LAMP AT SEAT 32G FOR EMERGENCY LIGHTS AT RT SEAT ROW 30 TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802160Battery Pack · dischargedJFK EMERGENCY LIGHTS AT RT SEAT ROWS 30 TO AFT CABIN INOPERATIVE. REPLACED BATTERY PACK M33401 FOR EMERGENCY LIGHTS AT RT SEAT ROW 30 TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802100Charger · inoperativeDFW EMERGENCY LIGHTS AT FORWARD COACH CABIN INOPERATIVE. REPLACED CENTER FORWARD BATTERY PACK CHARGER FOR EMERGENCY LIGHTS AT FORWARD COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801992Insulator · looseDFW EXTERIOR EMERGENCY LIGHT AT RT NR 4 DOOR INOPERATIVE. SECURED INSULATOR SLEEVE FOR EXTERIOR EMERGENCY LIGHT AT RT NR 4 DOOR. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801427Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801426Lamp · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT RIGHT NR FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT RIGHT NR FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800960Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 40G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 40G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800959Wire · exposedDFW - EMERGENCY LIGHT WIRING AT MAIN DECK CREW REST CLOSET LEFT AFT SIDE EXPOSED. REPLACED COVER FOR EMERGENCY LIGHT WIRING AT MAIN DECK CREW REST CLOSET LEFT AFT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800961Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 39C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800512Lamp · missingDFW - EMERGENCY LIGHT AT SEAT 31G HAS MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800511Lens · missingDFW - EMERGENCY LIGHT AT SEAT 31G HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800510Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26C HAS MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800508Lamp · missingDFW - EMERGENCY LIGHT AT SEAT 20C HAS MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800507Lens · missingDFW - EMERGENCY LIGHT AT SEAT 20C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800509Lens · missingDFW - EMERGENCY LIGHT AT SEAT 26C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800213Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800212Light · damagedDFW - EMERGENCY LIGHT AT L1 DOOR DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT L1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800211Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 39C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800210Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 35C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 35C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800209Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800219Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT LEFT AND RIGHT SEAT ROWS 9 TO 13 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT AND RIGHT SEAT ROWS 9 TO 13. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N799AN