N938AN
Service difficulty reports · 222
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 = 'N938AN' 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 = 'N938AN' 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 AALA20090928TUL01Battery Pack · weakEMERGENCY LIGHT BATTERY PACK AT M1671 FAILED FUNCTIONAL TEST. REPLACED BATTERY PACK.SDR AALA20090919MIA01Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK AT M1670 FAILED FUNCTIONAL TEST. REPLACED BATTERY PACK.SDR AALA20090928TUL12Wire Harness · damagedEMERGENCY AISLE LIGHTS AT SEAT ROWS 7DEF TO 11DEF INOPERATIVE. REPAIRED WIRING HARNESS FOR SEAT ROWS 7DEF TO 11DEF.SDR AALA20090928TUL11Battery Pack · smokeEMERGENCY LIGHT BATTERY PACK FORWARD ROW COACH SECTION RIGHT SIDE SMOKING. REPLACED BATTERY MODULE AT SEAT 7D.SDR AALA2009032200632Light · damagedDFW - EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 11D IS DAMAGED. REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 11D.SDR AALA200803193Lamp · missingDFW - EMERGENCY LIGHT AT SEAT 7D MISSING LAMPS. REPLACED LAMPS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803192Lens · missingDFW - EMERGENCY LIGHT AT SEAT 7D MISSING LENS. REPLACED LENS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803191Shroud · missingDFW - EMERGENCY LIGHT AT SEAT 7D MISSING SHROUD. REPLACED SHROUD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802070Light · inoperativeDFW EMERGENCY SLIDE LIGHT AT LT NR 1 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY SLIDE LIGHT AT LT NR 1 DOOR. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802071Light · inoperativeDFW EMERGENCY EXIT LIGHT AT RT AFT OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT RT AFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200800777Battery Pack · inoperativeDFW - EMERGENCY LIGHT AT AFT LEFT ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT LEFT ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800778Lamp · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT AFT LEFT OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 44G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071822Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN AREA OF STATION 511 RIGHT MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AREA OF STATION 511 RIGHT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071821Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN AREA OF STATION 750 MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AREA OF STATION 750 MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071820Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN AREA OF STATION 500 AFT OF PARTITION INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AREA OF STATION 500 AFT OF PARTITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070842Lens · missingMIA - EMERGENCY LIGHT AT SEAT 10D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070841Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 10D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070585Sign · brokenMIA - EMERGENCY EXIT LIGHT SIGN AT RIGHT NUMBER ONE DOOR BROKEN. SECURED SIGN FOR EMERGENCY EXIT LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070155Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 11A INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 11A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070156Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 13A INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 13A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060184Battery Pack · inoperativeTUL - SEAT MOUNTED EMERGENCY LIGHTS IN FIRST CLASS SECTION INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY LIGHTS IN FIRST CLASS SECTION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20001215Unknown · odorORD - FLT 1701 - AFTER TAKEOFF, CLIMBING THROUGH FL 220, STRONG ACRID ELECTRICAL FUMES REPORTED IN COCKPIT. EMERGENCY DESCENT AND LANDED ORD WITHOUT INCIDENT. INSPECTED ALL COCKPIT INSTRUMENT PANELS AND WIRING. COULD NOT DUPLICATE. SYSTEM GROUND CHECKED, N
Back to N938AN