N811NW
Service difficulty reports · 305
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 = 'N811NW' 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 = 'N811NW' 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 DALA1034413311Support Bracket · crackedDURING K-CHECK, FOUND CRACK IN RT UPPER WING TO BODY FAIRING NR192BT VERTICAL SUPPORT BRACKET RT UPPER WING TO BODY FAIRING NR192BT, VERTICAL SUPPORT BRACKET FABRICATED AND INSTALLED IAW ERA 487010-14, REV 0.SDR DALA104363311Oven · fireGALLEY NR 1 OVEN NR 3 ELECTRICAL FIRE, PULLED OVEN CIRCUIT BREAKERS AND LANDING WAS UNEVENTFUL. OVEN WAS REPLACED AND CHECKS OK.SDR NWAA092893311Slide · faultedDOOR 1R SLIDE LIGHT FAULTED ON EMERGENCY LIGHT TEST. THE EVACUATION SLIDE WAS REPLACED AND CHECKS OK.SDR NWAA092183311Controller · smokeGALLEY NR 2 OVEN PRODUCED LARGE AMOUNT OF SMOKE IN FLIGHT, PBE AND FIRE EXTINGUISHERS USED AND FLIGHT DIVERTED TO SNN AND LANDING WAS UNEVENTFUL. OVEN AND OVEN CONTROLLER WERE REPLACED AND CHECKS OK. REF LOG PAGE 6417752, 6417754 AND 6417753.SDR NWAA092023311Connector · unsecureEPSU TEST FAULTED THE 1R ESCAPE SLIDE LIGHT SW/EPSU (12WL), CLEANED WIRES AND SECURED CONNECTOR AND TESTS OK.
Back to N811NW