N806NW
Service difficulty reports · 248
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 = 'N806NW' 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 = 'N806NW' 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 DALA102203306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 40. REPAIRED IAW SRM 51-42-11.SDR DALA102183306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR48-FR51. REPAIRED IAW SRM 51-52-11.SDR DALA102173306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR38-FR39. REPAIRED IAW SRM 51-42-11.SDR DALA102163306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR53. REPAIRED IAW SRM 51-42-11.SDR DALA102153306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR40-FR47. REPAIRED IAW SRM 51-42-11.SDR DALA102143306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 52-FR 53. REPAIRED IAW SRM 51-42-11 AND SRM 51-31-15.SDR DALA102133306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 47. REPAIRED IAW SRM 51-42-11.SDR DALA102123306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 46. REPAIRED IAW SRM 51-42-11.SDR DALA102113306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 39-FR 47. REPAIRED IAW SRM 51-42-11.SDR DALA102103306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT FR 38-FR 39 . REPAIRED IAW SRM 51-42-11.SDR DALA102093306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK Y450 FR39. REPAIRED PER SRM 51-42-11.SDR DALA102083306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 37. REPAIRED IAW SRM 51-42-11.SDR DALA102073306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR53- FR54. REPAIRED IAW SRM 51-42-11.SDR DALA102423306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED AT FR53 TO 54. REPAIRED IAW SRM 53-31-15.SDR DALA102413306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED AT FR54 TO 58. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA102403306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR37 TO 38. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA102393306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR50. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA102383306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR53 TO 54. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA102373306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR55 TO 58. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA102363306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR68 TO 71. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA102353306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR39 TO 47. REPAIRED IAW SRM 53-31-13.SDR DALA102343306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462 CORRODED AT FR40 TO 41. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA102333306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED AT FR53 TO 54. REPAIRED IAW SRM 53-31-15.SDR DALA102323306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR67 TO 71. REPAIRED IAW SRM 53-00-15, AND SRM 51-42-11.SDR DALA102313306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK CORRODED AT FR59 TO 66. REPAIRED IAW SRM 51-42-11.SDR DALA102303306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR 37 TO 38. REPAIRED IAW SRM 51-42-11, AND SRM 53-00-15.SDR DALA102293306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR37. REPAIRED IAW SRM 51-42-11, AND SRM 53-00-15.SDR DALA102283306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK CORRODED AT FR52 TO 53. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR DALA102273306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2462 WAS CORRODED AT FR50 TO 58. REPAIRED IAW SRM 53-00-15.SDR DALA102263306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-1959 CORRODED AT FR52. REPAIRED IAW SRM 53-31-15.SDR DALA102063306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 62-FR 70. REPAIRED IAW SRM 51-42-11.SDR DALA101979763Floor Panel · crackedDURING "L" CHECK FOUND CRACK IN FLOOR PANEL NR66. REPAIRED IAW SRM 51-30-2 AND SRM 53-01.SDR DALA101893306Floor Support · corrodedDURING "H" CHECK FOUND CORROSION ON FLOOR SUPPORT UNDER PANEL 272KF. REPAIRED IAW SRM 51-42-11.SDR DALA101883306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1456 FR 19. REPAIRED IAW SRM 51-42-11.SDR DALA101863306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 55-57. REPAIRED IAW SRM 51-42-11.SDR DALA101843306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK Y450 FR 58-67. REPAIRED IAW SRM 51-42-11.SDR DALA101833306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 62-70. REPAIRED IAW SRM 51-42-11.SDR DALA101823306Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 59-60. REPAIRED IAW SRM 51-42-11.SDR DALA101783306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y1959 CORRODED AT FR 39-2. REPAIRED IAW SRM 53-31-15.SDR DALA101773306Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y953 AT FR37-2 HAS CORROSION. REPAIRED IAW SRM 53-00-15.SDR NWAA901983306Warning Light · false activationBATTERY EPSU (14WL) MESSAGE DURING TEST, REPLACED BATTERY AND TESTS OK.SDR NWAA 091313306Battery Pack · failedBATTERY EPSU (15WL) DOOR 3 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA09733306Battery · no testBATTERY EPSU (17WL) FAILED SYS CHECK, REPLACED BATTERY AND TESTS, OK. (K)SDR NWAA084613306Battery Pack · inoperativeBATTERY EPSU 12WL DOOR 1 FAILED CAPACITY CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA074383306Rib · crackedDURING INSPECTION PER AD 2006-22-14 FOUND CRACKS IN RT WING RIB NR 6. REPAIRED PER EA 33-208520.SDR NWAA074223306Rib · crackedDURING INSPECTION PER AD 2006-22-14, FOUND CRACKS IN LT WING RIB NR 6. REPAIRED PER EA 33-208520.SDR 0602593306Pump · leakingAT CRUISE RECEIVED "HYD G ENG 1 LO PR", FOLLOWED COM AND TURNED OFF NR 1 ENGINE PUMP. THEN RECEIVED "HYD G ENG 2 LO P", FOLLOWED COM AND TURNED OFF NR 2 ENGINE PUMP. THEN RECEIVED "HYD G RES LO LVL", FOLLOWED COM AND TURNED OFF GREEN ELECTRIC PUMP. DECLAREDSDR 0400563306Warning Light · false activationDURING CRUISE, RECEIVED MASTER CAUTION AND MOMENTARY ECAM WARNINGS FOR SMOKE IN THE IN-FLIGHT ENTERTAINMENT BAY, AFT CARGO COMPARTMENT, AND AVIONICS VENT. WARNINGS CLEARED WITHOUT CREW ACTION AND AIRCRAFT CONTINUED TO DESTINATION AND LANDED WITHOUT INCIDENT. R
Back to N806NW