N814NW
Service difficulty reports · 215
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 = 'N814NW' 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 = 'N814NW' 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 DALA13009993314Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE. INSTALLED NEW SIGN, OP'S NORMAL.SDR DALA13003883314Seat Track · corrodedSEAT TRACK -Y953 CORRODED AT FR15A. REPAIRED IAW PRI 510104-14, REV 0.SDR DALA13003873314Seat Track · corrodedSEAT TRACK, Y1456 CORRODED AT FR32. SEAT TRACK REPLACED IAW PRI 510621-14, REV 0.SDR DALA13004043314Seat Track · corrodedSEAT TRACK -Y1959 CORRODED AT ADJ FR53.2 & FR48. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA13004033314Seat Track · corrodedSEAT TRACK -Y450 CORRODED AT FR49 & FR53.1. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA13004023314Seat Track · corrodedSEAT TRACK Y1959 CORRODED AT FR48 & FR53.1. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA13004013314Seat Track · corrodedSEAT TRACK -Y2462 CORRODED FR51 & FR53.2. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA13004003314Seat Track · corrodedSEAT TRACK Y2462 CORRODED AT FR48 & FR53.1. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA13003993314Seat Track · corrodedSEAT TRACK Y450 CORRODED AT FR49 & FR53.1. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA12008773314Skin · dentedAFT CARGO DOOR HAS DENT AND CRACK ON INNER SKIN 30 INCHES AFT OF FWD CORNER 1.5" ABOVE THE SEAL. INSTALLED REPAIR IAW ERA 507206-14.SDR DALA1158713314Battery · failedDURING EMERGENCY LIGHT TEST BATTERY 15WL FAILED ESPU SYSTEM TEST. REPLACED BATTERY 15WL PER AMM. OPS CHECK GOOD.SDR DALA1155843314Connector · looseFLIGHT CREW FOUND EMERGENCY EXIT SIGN INOPERATIVE AT DOOR 3L. MAINTENANCE FOUND LOOSE CONNECTOR. TIGHTENED CONNECTOR, OPERATIONAL CHECK GOOD.SDR DALA1135933314Battery · faultedDURING EMERGENCY LIGHT TEST BATTERY NR2 FAULTED. MX REPLACED BATTERY AND TESTS OK.SDR DALA1129813314Wire · brokenDURING EMERGENCY LIGHT INSPECTION FOUND PATH LIGHT WIRE BROKEN BETWEEN SEATS 11 AND 12 RIGHT. REPAIRED WIRE AND TESTS OK.SDR DALA102573314Oven · smokeGALLEY 1-A OVEN NR 3 HAD SMOKE DUE TO POSSIBLE SPILLAGE, CIRCUIT BREAKER PULLED AND LANDING WAS UNEVENTFUL. OVEN REPLACED AND CHECKS OK.
Back to N814NW