N931AN
Service difficulty reports · 206
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 = 'N931AN' 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 = 'N931AN' 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 AALA20050407Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK AT LT OVERWING STATION 578 INOPERATIVE. REPLACED BATTERY PACK FOR EMERENCY LIGHTS AT LT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050406Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK AT RT OVERWING AT STATION 578 FAILED TEN MINUTE CAPACITY TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RT OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050332Filter · dirtyRDU - NUMBER 2 ENGINE OIL BYPASS WARNING CAME ON DURING CLIMBOUT WITH CLIMB POWER. RETURNED TO RDU AND LANDED WITHOUT INCIDENT. REPLACED OIL SUPPLY AND SCAVENGE FILTER. RAN ENGINE AT TAKEOFF SPEED FOR THREE MINUTES. ALL INDICATIONS NORMAL. ENGINEERING REQSDR AALA20040061Chip Detector · malfunctionedORD INFLIGHT/T1803/08 NUMBER 2 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED. RETURNED TO STATION. LANDED WITHOUT INCIDENT. REPLACED OIL FILTER AND FOUND SMALL AMOUNT OF METAL. REPLACED STARTER AS PRECAUTIONARY. EVALUATED FLIGHT DATA RECORDER. SENT OIL SAMPSDR AALA20030515Light · defectiveDURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT PATH LIGHTING AT FORWARD ENTRY DOOR OUTBOARD OF FLIGHT ATTENDANT SEAT INOPERATIVE. REPLACED EMERGENCY EXIT PATH LIGHTING ASSEMBLY AT FORWARD ENTRY DOOR OUTBOARD OF FLIGHT ATTENDANT SEAT. SYSTEM GROUND CHECKED NORMSDR AALA20030223Connector · disconnectedDURING OVERNIGHT MIANTENANCE, EMERGENCY EXIT ILGHTS ON BOTH SIDES OF AISLE BETWEEN END OF FIRST CLASS AND FRONT OF COACH INOPERATIVE. RECONNECTED EMERGENCY EXIT LIGHT BATTERY CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N931AN