N1709A
Service difficulty reports · 455
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 = 'N1709A' 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 = 'N1709A' 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 UIEA2017071201154Blade · nickedNR 1 ENGINE FAN BLADE HAVE NICKS ON L/E BLADE NR 7. REWORKED ENGINE FAN BLADE IAW AMM 72-31-02.SDR UIEA2017071201163Igniter · corrodedAPU IGNITER TIP CORRODED. REMOVED AND REPLACED APU IGNITER IAW AMM 49-41-02-404-006. PERFORMED AN OPS TESTED IAW AMM 49-11-00-802-002.SDR UIEA2017071201162Seal · deterioratedLEFT WING L/E BULLNOSE SEAL TORN/DETERIORATED(<P>REMOVED AND REPLACED SEAL ON LEFT WING NR 1 ENGINE PYLON L/E FIXED BULLNOSE IAW AMM 20-00-00.SDR UIEA2017071201159Seal · damagedNR 1 ENGINE AFT EXHAUST CONE L/E FINGER SEALS BROKEN, CRACKED AND CHAFED. REMOVED AND REPLACED THE NR 1 ENGINE AFT EXHAUST CONE L/E FINGER SEALS IAW SRM 51-40-02 AND AMM 20-11-00,SDR UIEA2017071201164Battery · dischargedAPU DID NOT CRANK, APU DOOR FAULT ON LOWER EICAS. TROUBLESHOT THE SYSTEM AND FOUND THAT APU DOOR ACTUATOR WAS NOT EQUIPPED WITH PROPER VOLTAGE TO OPERATE. CHARGED THE APU BATTERY WITH APU BATTERY CHARGER IAW AMM 24-31-05-424-007, STEP E. APU OPS CHECKED GOO
Back to N1709A