N805NW
Service difficulty reports · 283
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 = 'N805NW' 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 = 'N805NW' 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 DALA101423305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 37. REPAIRED IAW SRM 53-00-15.SDR DALA101313305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-950 CORRODED BETWEEN FR53 AND 55. REPAIRED IAW SRM 53-00-15, AND SRM 53-31-15.SDR DALA101303305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1456 CORRODED BETWEEN 21 AND 22. REPAIRED IAW SRM 53-00-15, AND REPLACEMENT ON NRC 160-230.SDR DALA101293305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED BETWEEN FR72 AND 73. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA101283305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462 CORRODED FR37. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101273305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED BETWEEN FR40 AND FR47. REPAIRED IAW SRM 53-31-15, SRM 51-42-11, AND SRM 51-44-11.SDR DALA101263305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED AT FR59. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101253305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462 CORRODED AT FR40, FR42, AND FR44. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA101243305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462 CORRODED AT FR57. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101233305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR 69, AND BETWEEN FR 70-71. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101223305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR 69 AND BETWEEN FR 70 AND 71. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101213305Seat Track · corrodedDURING "H" CHECK, FOUND SEAT TRACK Y-2462 CORRODED BETWEEN 63 AND 64, AND AT 65. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101203305Seat Track · corrodedDURING "H" CHECK, FOUND SEAT TRACK Y-450 CORRODED BETWEEN FR38 AND 39. REPAIRED IAW SRM 53-31-15, SRM 51-42-11, AND SRM 51-44-11.SDR DALA101193305Seat Track · corrodedDURING "H" CHECK, FOUND SEAT TRACK Y-1959 CORRODED BETWEEN FR 32-34. REPAIRED IAW SRM 53-00-14, AND SRM 51-42-11.SDR DALA 101183305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED BETWEEN FR 62-63, FR 66-67, FR 68, AND FR 71. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA101173305Seat Track · corrodedDURING "H" CHECK, FOUND SEAT TRACK Y-2462, CORRODED AT FR59, AND BETWEEN FR 60-62. REPAIRED IAW SA5100-01581-1, SRM 53-00-15, SRM 51-42-11, AND SRM 51-44-11.SDR DALA101163305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462, BETWEEN FR 62-63, FR 65-66, AND FR71 CORRODED. REPAIRED IAW SRM 53-00-15, AND SA5100-01581-1 REV H.SDR DALA101143305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 40. REPAIRED PER SRM 51-42-11.SDR DALA101133305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 35. REPAIRED IAW SRM 53-00-15.SDR DALA101123305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1456 BETWEEN FR 20 AND FR 21. REPAIRED IAW SRM 51-42-11.SDR DALA101113305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 BETWEEN FR 39 TO FR 39.2. REPAIRED IAW SRM 51-42-11.SDR DALA101093305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FROM FR 55 TO FR 57. REPAIRED IAW SRM 53-00-15.SDR DALA101153305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450, BETWEEN FR73 AND 75 WAS CORRODED. REPAIRED IAW SRM 53-00-15, SRM 51-42-11, AND SRM 51-44-11.SDR DALA101083305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 BETWEEN FR 37.1 AND FR 37.2. REPAIRED PER SRM 51-42-11.SDR DALA101873305Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 51-FR 53. REPAIRED IAW SRM 53-31-15 FIG 101.SDR DALA100613305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y450 CORRODED AT FR54. REPLACED IAW SRM 51-42-11.SDR DALA100603305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y450 CORRODED AT FR58 AND FR59. REPLACED IAW SRM 51-42-11.SDR DALA100593305Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y450 CORRODED AT FR42, AND FR45. REPLACED IAW SRM 51-42-11.SDR NWAA09343305Battery · dischargedBATTERY EPSU (15WL) MESSAGE DURING TEST, REPLACED BATTERY AND TESTS, OK. (K)SDR NWAA09353305Battery · dischargedBATTERY EPSU (14WL) MESSAGE DURING TEST, REPLACED BATTERY AND TESTS, OK. (K)SDR NWAA083643305Battery · faultyPERFORMING EMERGENCY LIGHTS OPERATION CHECK, EPSU 12WL & 15 WL FAULTS BATTERY. REPLACED BATTERY OF EPSU 12WL & 15WL, TESTS OK (L/P 2908998, 2909005). (S)SDR NWAA082823305Power Supply · faultedEPSU FAULT (17WC), REPLACED POWER SUPPLY (17WC) AND CHECKS GOOD. (A)SDR 0602053305Video Monitor · contaminatedVIDEO MONITOR 24B STARTED EMITTING WHITE SMOKE. MONITOR WORKS OK AND NO EVIDENCE OF ELECTRICAL HEAT DAMAGE WAS FOUND. FOUND A MELTED CHOCOLATE AT THE BOTTOM AND BEHIND THE MONITOR. REMOVED AND REPLACED THE MONITOR AS A PRECAUTION AND CHECKS OK.
Back to N805NW