N1409A
Service difficulty reports · 458
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 = 'N1409A' 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 = 'N1409A' 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 UIEA2017112702312Frame · wornNR 2 ENGINE LT CORE COWL AFT HAT FRAME REPAIR DOUBLERS FOUND WORN. NR 2 ENGINE LH CORE COWL AFT SECTION WORN HAT FRAME REMOVED AND REPLACED IAW SRM 51-40-02 REV 105.SDR UIEA2017112702314Frame · wornNR 1 ENGINE LT CORE COWL AFT HAT FRAME REPAIR DOUBLERS FOUND WORN. NR 1 ENGINE LH CORE COWL AFT WORN HAT FRAME REMOVED AND REPLACED AS PER B767-300 SRM 51-40-02 REV 105</P>)SDR UIEA2017112802331Priority Valve · no testNR 2 ENGINE PRV FAILED THUMB CHECK. NR 2 ENGINE PRV REMOVED AND REPLACED IAW AMM 36-11-18 REV 122.SDR UIEA2017120502360Control Unit · failedNR 2 ENGINE HEATER CONTROL UNIT FOUND WORN DURING RECEIVING INSPECTION. NR 2 HEATER CONTROL UNIT REMOVED AND REPLACED IAW AMM 73-21-22 REV 122 AND ECU STATIC TEST CARRIED OUT IAW AMM 71-00-00-725-268-H03 REV 122 FOUND SATISFACTORY.SDR UIEA2017120502361Switch · malfunctionedWHEN APU DC PUMP RUNNING, EICAS MSG 'DC FUEL PUMP ON' DOES NOT SHOW. APU DC FUEL PUMP PRESSURE SWITCH REMOVED, REPLACED AND TESTED IAW AMM 28-25-03 REV 122, FOUND SATISFACTORY.SDR UIEA2017120502364Connector · damagedP37 PANEL ELECTRICAL CONNECTOR (D05052P) FOUND TERM 8 PIN LOCK BROKEN. REMOVED AND REPLACED IAW SWPM 20-61-11 REV 66 FOUND SATISFACTORY.SDR UIEA2017120502365Connector · damagedFOUND CONNECTOR D5656P PIN 38 UNABLE TO LOCK., REMOVED AND REPLACED IAW SWPM 20-61-11 REV 66 FOUND SATISFACTORY.SDR UIEA2017112802330Check Valve · chafedA/C BAY, RT ISOLATION BYPASS CHECK VALVE FOUND THE HOUSING CHAFDED. THE RT ISOLATION BYPASS VALVE WAS REMOVED, REPLACED, AND LEAK CHECKED IAW AMM 21-51-15, AND 36-11-00, REV 122. FOUND SATISFACTORY.
Back to N1409A