N783AN
Service difficulty reports · 324
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 = 'N783AN' 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 = 'N783AN' 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 AALA20072415Lens · missingDFW - EMERGENCY LIGHT AT SEAT 24C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHTS AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072417Lens · missingDFW - EMERGENCY LIGHT AT SEAT 31C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072283Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT LEFT AND RIGHT AFT COACH INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT AND RIGHT AFT COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071865Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK AT RIGHT NUMBER FOUR DOOR M33409 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK AT RIGHT NUMBER FOUR DOOR M33409. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071864Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK AT RT NR 2 DOOR M33097 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK AT RT NR 2 DOOR M33097. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071863Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK M33424 AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK M33424 AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071862Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK AT LEFT NUMBER TWO DOOR M33099 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK AT LEFT NUMBER TWO DOOR M33099. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071861Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK AT RIGHT NUMBER TWO DOOR M33098 INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK AT RIGHT NUMBER TWO DOOR M33098. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071473Lens · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071192Lens · damagedDFW - EMERGENCY LIGHT AT SEAT 20C HAS DAMAGED LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071191Bulb · damagedDFW - EMERGENCY LIGHT AT SEAT 20C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071148Battery Pack · inoperativeORD - EMERGENCY LIGHTS AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED BATTERY PACK M33093 FOR EMERGENCY LIGHTS AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071045Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT AFT RIGHT DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT RIGHT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070487Lens · missingLHR EMERGENCY LIGHT AT FIRST CLASS CLOSET AREA NEAR LEFT NUMBER ONE DOOR HAS MISSING LENS. REPLACED LIGHT ASSEMBLY AT FIRST CLASS CLOSET AREA NEAR LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070354Bulb · burned outMIA - FOUND EMERGENCY LIGHT ABOVE SEAT 3D INOPERATIVE. RELAMPED EMERGENCY LIGHT ABOVE SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070353Bulb · burned outMIA - EMERGENCY LIGHT ABOVE SEAT 3A INOPERATIVE. RELAMPED EMERGENCY LIGHT ABOVE SEAT 3A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070321Lens · missingDFW - FOUND EMERGENCY LIGHTS AT SEAT 25C HAS LENS COVER MISSING. REPLACED LENS COVER FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070322Connector · looseDFW - EMERGENCY LIGHTS AT RIGHT NUMBER FOUR DOOR INOPERATIVE. RESEATED BATTERY PACK CONNECTOR FOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070320Light · inoperativeDFW - FOUND EMERGENCY LIGHTS AT SEAT 25C INOPERATIVE. REPLACE EMERGENCY LIGHT ASSEMBLY AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060289Lens · missingDFW - EMERGENCY PATH LIGHT AT SEAT 26G MISSING LENS. REPLACED LIGHT LENS AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041123Battery Pack · inoperativeDFW - SEAT EMERGENCY ESCAPE PATH LIGHT IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR SEAT EMERGENCY ESCAPE PATH LIGH IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030490Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT PATH LIGHT AT 3G INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT SEAT 3G. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030489Light · inoperativeDURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT PATH LIGHT AT 2D INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT SEAT 2D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000394Pin · looseDFW - DURING MAINTENANCE, ALL EMERGENCY EXIT ESCAPE PATH LIGHTS IN COACH INOPERATIVE. REPAIRED CONNECTOR AT SEAT 33C. SYSTEM GROUND CHECK NORMAL OPERATION. (M)
Back to N783AN