N819NW
Service difficulty reports · 202
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 = 'N819NW' 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 = 'N819NW' 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 DALA13036383319Battery · no testDURING ESPU TEST, FOUND CABIN EMERGENCY LIGHT BATTERIES 13WL AND 16WL FAILED ESPU CAP TEST. REPLACED BATTERIES IAW AMM 33-51.SDR NWAA074343319Line · leakingAT CRUISE 5 HOURS AFTER TAKE OFF RECEIVED MESSAGE "HYD G SYS LEAK" AND HYDRAULIC QUANTITY WAS SLIGHTLY BELOW AMBER HASH MARKS, FOLLOWED COM AND TURNED OFF GREEN HYDRAULIC SYSTEM. ON APPROACH TURNED PUMPS ON, DROPPED THE GEAR AND THE REMAINING HYDRAULIC FLUID
Back to N819NW