N907AN
Service difficulty reports · 258
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 = 'N907AN' 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 = 'N907AN' 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 AALA20070349Battery Pack · dischargedLGA - FOUND EMERGENCY LIGHT AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FOWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070115Battery Pack · inoperativeLAX - EMERGENCY LIGHTS FROM SEAT ROWS 22 TO 28 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM SEAT ROWS 22 TO 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050400Battery Pack · inoperativeEMERGENCY LIGHTS AT SEAT 19ABC INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT 19ABC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031450Battery Pack · dischargedBOS EMERGENCY LIGHTS AT ROWS 7DEF THROUGH 10DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROWS 7DEF THROUGH 10DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20011603Battery Pack · dischargedDEN - DURING OVERNIGHT MAINTENANCE, EMERGENCY FLOOR PATH LIGHTING AT 7D INOPERATIVE. REPLACED BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010671Valve · leakingATL - FLT 1066 - EN ROUTE MIA-ORD - SHORTLY AFTER TAKEOFF, DETECTED AN UNWANTED FUEL TRANSFER CAUSING A FUEL IMBALANCE. DIVERTED ATL AND LANDED WITHOUT FURTHER INCIDENT. REPLACED FUEL CROSSFIELD VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010379Light · defectiveORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT 12 AND 13D DIM. REPLACED EMERGENCY LIGHT BULB AT SEAT 12D AND 13D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991619Cable · misriggedORD - FLT 1025 - DURING PRE-FLIGHT, OXYGEN MASKS WERE INADVERTENTLY DEPLOYED BY FLIGHT CREW. OXYGEN CANISTER WAS NOT RIGGED PROPERLY. PROPERLY RIGGED CABLES TO OXYGEN CANISTER AT SEAT 20 DEF AND RESTOWED ALL OTHE MASKS. SYSTEM GROUND CHECKED, NORMAL OPERATI
Back to N907AN