N804NW
Service difficulty reports · 331
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 = 'N804NW' 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 = 'N804NW' 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 DALA103143314Floor Support · corrodedDURING "H" CHECK FOUND CORROSION ON LT FLOOR PANEL SUPPORT AT Y1959 FR35. REPAIRED IAW SRM 51-42-11.SDR DALA103133304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON LT SEAT TRACK AT Y1959 FR35. REPAIRED IAW SRM 51-42-11.SDR DALA103123304Floor Support · corrodedDURING "H" CHECK FOUND CORROSION ON LT FLOOR SUPPORT AT Y1959 FR33-FR35. REPAIRED IAW SRM 51-42-11.SDR DALA103113304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1552 FR32-FR34. REPAIRED IAW SRM 51-42-11.SDR DALA103103304Floor Support · corrodedDURING "H" CHECK FOUND CORROSION ON RT FLOOR PANEL SUPPORT AT Y1456 FR33. REPAIRED IAW SRM 51-42-11.SDR DALA103093304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1456 FR19, FR23 AND FR25. REPAIRED IAW SRM 51-42-11.SDR DALA103083304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR70. REPAIRED IAW SRM 51-42-11.SDR DALA103073304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR69. REPAIRED IAW SRM 51-42-11.SDR DALA103063304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR64. REPAIRED IAW SRM 51-42-11.SDR DALA103053304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR61. REPAIRED IAW SRM 51-42-11.SDR DALA103043304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR58. REPAIRED IAW 51-42-11.SDR DALA103033304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR57. REPAIRED IAW SRM 51-42-11.SDR DALA103023304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR56. REPAIRED IAW SRM 51-42-11.SDR DALA103013304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR53. REPAIRED IAW SRM 51-42-11.SDR DALA103003304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR47. REPAIRED IAW SRM 51-42-11.SDR DALA102993304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR46. REPAIRED IAW SRM 51-42-11.SDR DALA102983304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR40. REPAIRED IAW SRM 51-42-11.SDR DALA102973304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y450 FR 39. REPAIRED IAW SRM 51-42-11.SDR DALA102763304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-2463 CORRODED AT FR48 TO 53. REPAIRED IAW SRM 53-31-15, AND SRM 51-42-11.SDR NWAA091923304Battery Pack · no testDOOR 4L BATTERY FAILED THE EMERGENCY LIGHTING CHECK, REPLACED BATTERY AND CHECKED OK.SDR NWAA 091763304Battery Pack · failedBATTERY EPSU (15WL) DOOR 3 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA09693304Connector · damagedIAW SHOP REPORT, OVEN TEARDOWN FOUND SMOKE AND ELECTRICAL ARCHING DAMAGE ON AN INTERNAL CONNECTOR. (K)SDR NWAA084903304Battery · no testBATTERY EPSU 11 WL FAILED CAPACITY CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA084893304Battery · no testBATTERY EPSU 13WL DOOR 2L FAILED CAPACITY CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA084883304Battery Pack · failedBATTERY EPSU 17WL DOOR 4L FAILED CAPACITY CHECK, REPLACED BATTERY AND TESTS OK.SDR NWAA084663304Battery Pack · inoperativeBATTERY EPSU 14WL MSG DURING TEST. REPLACED BATTERY AND TESTS OK.SDR NWAA073773304Rib · crackedDURING INSPECTION PER AD 2006-22-14, FOUND CRACK IN RIB 6 RT AND RIB 6 LT. REPAIRED PER EA 33-211276.SDR NWAA072063304Power Supply · faultedTHE (EPSU) EMERGENCY POWER SUPPLY UNIT FOR THE (LDMCR) LOWER DECK MOBILE CREW REST FAULTED DURING TEST. REMOVED AND REPLACED THE EPSU 32-3300-4-0074 AND CHECKED OK.SDR 0601723304Epsu · failedEPSU TEST FAULTED BATTERY EPSU 12WL DOOR 1. REMOVED AND REPLACED EPSU AND TESTED OK. SDR 0600083304Oven · smokeWORLD BUSINESS CLASS OVEN NR 3 HAD AN ELECTRICAL FIRE (SMOKE). MAINTENANCE FOUND OVEN CIRCUIT BREAKER TRIPPED. CB WAS COLLARED AND OVEN WAS DEFERRED INOP. OVEN WAS REPLACED IN AMS AND TESTED OK.SDR 0402103304Wheel · fireUPON ARRIVAL AT THE GATE, FIRE WAS COMING FROM THE NR 7 WHEEL/BRAKE ASSEMBLY. BRAKE COOLED AND THE FIRE EXTINGUISHED. INSPECTED GEAR AND REPLACED THE WHEEL AND BRAKE ASSEMBLY. OPERATIONAL CHECK GOOD.
Back to N804NW