N932AN
Service difficulty reports · 216
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 = 'N932AN' 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 = 'N932AN' 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 AALA20090701TUL01Battery Pack · failedM1672 BATTERY PACK IN AFT CABIN FAILED OPS CHECK. REPLACED BATTERY PACK. OPS CHECK GOOD PER MM33-51-062.SDR AALA2009062100002Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 24D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24D.SDR AALA2009031100573Battery Pack · dischargedATL - BATTERY PACK THAT CONTROLS ROWS 15, 17, 20 LEFT SIDE INOPERATIVE. REPLACED BATTERY PACK.SDR AALA200802403Lamp · inoperativeDFW EMERGENCY EXIT SPOT LIGHT AT SEAT 13A INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT SPOT LIGHT AT SEAT 13A. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200800901Light · inoperativeATL - EMERGENCY LIGHT AT SEAT 14D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800900Light · inoperativeATL - EMERGENCY LIGHT AT SEAT 13D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800308Lamp · inoperativeMIA - EXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071833Light · brokenMIA - EMERGENCY LIGHT AT FORWARD RIGHT AFT OF FLIGHT ATTENDANT SEAT BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FORWARD RIGHT AFT OF FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071450Battery Pack · inoperativeTUL- EMERGENCY LIGHTS AT FORWARD GALLEY INOPERATIVE. REPLACED BATTERY PACK AT STATION 325 FOR EMERGENCY LIGHTS AT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071451Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN MID CABIN INOPERATIVE. REPLACED BATTERY PACK BETWEEN STATION 600 AND 650 FOR EMERGENCY LIGHTS AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071449Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK BETWEEN STATION 700 AND 800 FOR EMERGENCY LIGHTS AT MID COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060851Bulb · inoperativeMIA - EMERGENCY LIGHT AT SEAT 18D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060130Skin · damagedTUL - FOUND A GOUGE WITH TWO DENTS IN THE FUSELAGE SKIN LOCATED STATION 404, SIX INCHES FORWARD OF PRIMARY STATIC PORT. AREA IS SIX INCHES BY SIX INCHES. ALL IN REDUCED VERTICAL SEPARATION MINIMA (RSVM) AREA. INSTALLED REPAIR DOUBLER OVER DAMAGE CUTOUT PER SDR AALA20040650Light · damagedSFO - FLOOR PROXIMITY LIGHT ASSEMBLY AT SEAT 14D DAMAGED. REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040219Battery Pack · inoperativeDTW SEAT MOUNTED EMERGENCY EXIT LIGHTS AT AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY EXIT LIGHT AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031480Battery Pack · dischargedDFW DURING OVERNIGHT MAINTENANCE FOUND SEAT MOUNTED EMERGENCY LIGHTS ROWS 7D-11D INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS ROWS 7D-11D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N932AN