N794AN
Service difficulty reports · 276
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 = 'N794AN' 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 = 'N794AN' 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 AALA20130328014Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130121002Lens · missingSEAT 24G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130121001Lens · missingSEAT 26C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130118016Light · missingSEAT 26C ESCAPE PATH LIGHT MISSING LAMPS. REPLACED LAMPS FOR SEAT 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130118015Light · inoperativeSEAT 23C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 23C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130118014Lens · missingSEAT 39C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 39C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130118013Light · weakSEAT 31C ESCAPE PATH LIGHT DIM. REPLACED LAMP FOR SEAT 31C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130118012Light · inoperativeRIGHT NUMBER 2 AFT EXIT SIGN INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 AFT EXIT SIGN. OPS CHECK NORMAL.SDR AALA20130118011Light · missingSEAT 24G ESCAPE PATH LIGHT MISSING LAMPS. REPLACED LAMPS FOR SEAT 24G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030031Light · inoperativeSEAT 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030029Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030026Light · inoperativeROW 23G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030015Lens · missingSEAT 32C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 32C ESCAPE PATH LIGHT.SDR AALA20121030014Lens · missingSEAT 24C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030013Lens · missingROW 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030012Light · inoperativeROW 20C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 20C ESCAPE PATH LIGHT, OPS CHECK NORMAL.SDR AALA20121030011Lens · missingROW 23G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 23G ESCAPE PATH LIGHT, OPS CHECK NORMAL.SDR AALA20121030010Light · inoperativeROW 31G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR SEAT 31G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030009Light · inoperativeSEAT 36G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR SEAT 36G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030008Light · inoperativeSEAT 40G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMPS FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030033Lens · missingSEAT 24C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030032Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030030Light · inoperativeROW 31G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 31G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030028Light · inoperativeSEAT 36G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 36G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030027Light · inoperativeSEAT 40G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030025Lens · missingSEAT 32C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 32C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030023Lens · missingSEAT 32C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 32C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030022Light · inoperativeSEAT 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030021Lens · missingROW 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121030020Light · inoperativeROW 20C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120109MIA01Power Supply · inoperativeEMERGENCY CEILING LIGHTS AT SEATS 36H, 39H AND 12D INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY AND REPAIRED CONNECTOR WIRE AT SEAT 12D. OPS CHECK NORMAL.SDR AALA20110419MIA01Light · inoperativeEMERGENCY LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. OPS CHECK NORMAL.SDR AALA20110225TUL05Light · brokenRIGHT FORWARD GALLEY EMERGENCY LIGHT HOUSING BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT FORWARD GALLEY. OPS CHECK NORMAL.SDR AALA20110225TUL04Lens · missingEMERGENCY LIGHT AT 36C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 36C. OPS CHECK NORMAL.SDR AALA20110225TUL03Lens · missingEMERGENCY LIGHT AT SEAT 32C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 32C. OPS CHECK NORMAL.SDR AALA20110225DFW01Light · inoperativeEMERGENCY LIGHT AT SEAT 32C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 32C. OPS CHECK NORMAL.SDR AALA20110204TUL11Lens · missingSEAT 45G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 45G. OPS CHECK NORMAL.SDR AALA20110204TUL10Lens · missingSEAT 21G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21G. OPS CHECK NORMAL.SDR AALA20110204TUL09Lens · missingSEAT 24G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20110204TUL08Lens · missingSEAT 25G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 25G. OPS CHECK NORMAL.SDR AALA20110204TUL07Lens · missingSEAT 34G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 34G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110204TUL06Light · inoperativeSEAT 45G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR 45G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110204TUL05Light · inoperativeSEAT 21G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR 21G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110204TUL04Light · inoperativeSEAT 24G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR 24G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110204TUL03Light · inoperativeSEAT 25G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR 25G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110202MIA01Light · inoperativeSEAT 34G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR 34G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110121TUL12Lens · missingROW 21G EMERGENCY LIGHT MISSING LENS. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. OPS CHECK NORMAL.SDR AALA20110121TUL11Connector · unsecureROW 13D ESCAPE PATH LIGHT INOPERATIVE. RE-SECURED CONNECTOR FOR ROW 13D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110121DFW07Battery Pack · dischargedRIGHT NUMBER 4 DOOR ESCAPE PATH LIGHT ON SIDEWALLS AND CEILING INOPERATIVE. REPLACED BATTERY PACK M33408 AT RIGHT NUMBER 4 DOOR. OPS CHECK NORMAL.SDR AALA20110121DFW06Light · inoperativeROW 25C ESCAPE PATH LIGHT LAMP INOPERATIVE AND MISSING LENS. REPLACED LIGHT ASSEMBLY FOR ROW 25C ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N794AN