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 DALA2015101306140Seat Track · corrodedDURING M-CHECK, FRAMES 33-37, Y2462, SEAT TRACK FOUND CORRODED. REPLACED THE SEAT TRACK.SDR DALA2015100805995Seat Track · corrodedDURING M-CHECK, CORROSION WAS FOUND ON THE SEAT TRACK AT FRAME 74-75, Y450 AFT CABIN. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA2015093005876Seat Track · corrodedDURING M-CHECK, CORROSION WAS FOUND ON THE SEAT TRACK AT FR 33, Y2462. REPLACED SEAT TRACK.SDR DALA2015051803310Battery Pack · inoperativeDURING HFA CHECK EPSU AT DOOR 1L, 11WL AND 2L, 13WL, FAILED. REPLACED BATTERIES AT DOORS 1L, 2L, AND 3L.SDR DALA2015040102576Wire · shortedEMERGENCY LIGHTS OUT ON SEATS 13, 14, 15. FOUND WIRE AT SEAT 14 SHORTING TO GROUND REPAIRED WIRE IAW ESPM 20-43-10. REPLACED & OPS CHECKED EPSU.SDR DALA2015012900697Lens · missingEMERGENCY LIGHT LENS MISSING AND LIGHT INOPERATIVE. R & R LIGHT ASSY.SDR DALA2014111806150Connector · unsecureEMERGENCY LIGHT SEAT 20B IS INOPERATIVE. SECURED THE CONNECTOR.SDR DALA14009283304Seat Track · corrodedSEAT TRACK FRAMES 73-75 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG103. R & R IAW SRM 51-42-11.SDR DALA14009273304Seat Track · corrodedSEAT TRACK FRAME 85 FOUND CORRODED AND CRACKED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED AND REPLACED SUPPORT SRM 51-42-11.SDR DALA14009263304Seat Track · corrodedSEAT TRACK BETWEEN FRAMES 73-74 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED AND REPLACED IAW SRM 51-42-11.SDR DALA14009253304Seat Track · corrodedSEAT TRACK FRAME 73 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED AND REPLACED IAW SRM 51-42-11.SDR DALA14009243304Seat Track · corrodedSEAT TRACK FRAME 73 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. R & R IAW SRM 51-42-11.SDR DALA14009233304Seat Track · corrodedSEAT TRACK FRAME 76 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53- 41-14, FIG 103. R & R IAW SRM 51-42-11.SDR DALA14009223304Seat Track · corrodedSEAT TRACK Y-YB BETWEEN FRAMES 73 - 74. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED AND RPLACED IAW SRM 51-42-11.SDR DALA14009213304Seat Track · corrodedSEAT TRACK Y +794.3 BETWEEN FRAMES 73 - 74 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. R & R IAW SRM 51-42-11.SDR DALA14009203304Seat Track · corrodedSEAT TRACK Y-794 AT FRAME 73 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. R & R IAW SRM 51-42-11.SDR DALA14009193304Seat Track · corrodedSEAT TRACK Y-400 AT FRAME 78 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA14009183304Seat Track · corrodedSEAT TRACK +YC AT FRAME 74 FOUND CORRODED. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. R & R SEAT TRACK SRM 51-42-11.SDR DALA14009173304Seat Track · corrodedSEAT TRACK Y 400 FOUND CORRODED AT FRAME 78. CORROSION REMOVED IAW SRM 53-41-14 FIG 103 AND FOUND OUT OF LIMITS. R & R THE SEAT TRACK IAW SRM 51-42-11.SDR DALA14009163304Seat Track · corrodedSEAT TRACK Y 2462 FOUND CORRODED AT FRAME 59. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW SRM 51-42-11 AND DWG F53477210 ISSUE D.SDR DALA14009143304Seat Track · corrodedSEAT TRACK Y-1959 FOUND CORRODED AT FRAME 62. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11 AND REWORK IAW DWG F53477211, ISSUE G.SDR DALA14009133304Seat Track · corrodedSEAT TRACK Y 450 FOUND CORRODED AT FRAME 39.1. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11 AND DWG F57112436, ISSUE D.SDR DALA14009123304Seat Track · corrodedSEAT TRACK Y 450 FOUND CORRODED AT FRAME 39. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11 AND DWG F53310898, ISSUE D.SDR DALA14009113304Seat Track · corrodedSEAT TRACK Y 1959 FOUND CORRODED AT FRAMES 63 - 70. REMOVED CORROSION SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW DWG F53477211, ISSUE G AND SRM 51-42-11.SDR DALA14009103304Seat Track · corrodedSEAT TRACK Y-450 FOUND CORRODED FRAMES 40 - 46. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK R & R SRM 51-42-11 AND DWG F57112436.SDR DALA14009093304Seat Track · corrodedSEAT TRACK Y-2462 FOUND CORRODED FRAMES 59 - 62. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA14009083304Seat Track · corrodedSEAT TRACK Y-1959 FOUND CORRODED FRAMES 40.3 - 45. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK SRM 51-42-11.SDR DALA14009073304Seat Track · corrodedSEAT TRACK Y-450 FOUND CORRODED FRAMES 57-58. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA14009063304Seat Track · corrodedSEAT TRACK Y-1959 FOUND CORRODED FRAME 37. REMOVED CORROSION IAW SRM 51-74-00 & FOUND OUT OF LIMITS SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA14009603304Seat Track · chafedSEAT TRACK Y=953 FOUND CHAFED AT FRAME 60. REMOVED CHAFE IAW SRM 51-73-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11 AND DWG F53477233, ISSUE A.SDR DALA14009153304Seat Track · corrodedSEAT TRACK Y-2462 FOUND CORRODED AT FRAME 57.3. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW DWG F53476210, ISSUE C AND SRM 51-42-11.SDR DALA14009043304Seat Track · corrodedSEAT TRACK Y -450 FOUND CORRODED FRAMES 60, 61, AND 63. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW DWG F53477214 ISSUE F AND SRM 51-42-11.SDR DALA14008923304Seat Track · corrodedSEAT TRACK Y=450 FOUND CORRODED AT FRAME 53.2. CORROSION REMOVED IAW SRM 51-74-00, AND FOUND OUT OF LIMITS IAW SRM 53 -31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008913304Seat Track · corrodedSEAT TRACK Y=-1959 FOUND CORRODED AT FRAME 53.5. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14008903304Seat Track · corrodedSEAT TRACK Y=450 FOUND CORRODED AT FRAME 60. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW DWG F53477214, ISSUE F AND SRM 51-42-11.SDR DALA14008893304Seat Track · corrodedSEAT TRACK Y=450 FOUND CORRODED AT FRAMES 40.1, 41, AND 47. REMOVED CORROSION IAW SRM 51-74-00, AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 102. R & R SEAT TRACK IAW DWG F57112436, ISSUE B AND SRM 51-42-11.SDR DALA14008883304Seat Track · corrodedY=1959 SEAT TRACK FOUND CORRODED AT FRAMES 40.3 - 41. CORROSION REMOVED IAW SRM 51-74-00, AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008873304Seat Track · corrodedSEAT TRACK Y=2462 FOUND CORRODED FRAMES 50 - 53. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS SRM 53-31-15, FIG 101. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14008863304Seat Track · corrodedSEAT TRACK-450 FOUND CORRODED FRAMES 50 - 53. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008853304Seat Track · corrodedSEAT TRACK Y=450 FOUND CORRODED FRAMES 50 - 53.1. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS SRM 53 -31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008843304Seat Track · corrodedSEAT TRACK -450 CORRODED FRAMES 68 - 69. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14009593304Seat Track · corrodedSEAT TRACK Y=450 FRAME 75 FOUND CORRODED. SEAT TRACK REPAIRED IAW SRM 53-41-14, FIG 211.SDR DALA14009053304Seat Track · corrodedSEAT TRACK Y-2462 FOUND CORRODED FRAMES 40.2, 43, AND 46 REMOVED CORROSION IAW SRM 51-74-00 & FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA14009033304Seat Track · corrodedSEAT TRACK Y 1959 FOUND CORRODED FRAMES 49, 52, AND 53.2 REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11 AND DWG F53312652, ISSUE C.SDR DALA14009023304Seat Track · corrodedSEAT TRACK Y 1959 FOUND CORRODED FRAMES 56, 57.1, AND 57.2. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14009013304Seat Track · corrodedSEAT TRACK Y -953 FOUND CORRODED FRAMES 43 - 45. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-11-15 FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14009003304Seat Track · corrodedSEAT TRACK Y-953 FOUND CORRODED FRAMES 51-53. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008993304Seat Track · corrodedSEAT TRACK Y 450 FOUND CORRODED FRAMES 68 - 69. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW IAW SRM 53-00-15, FIG 102. R & R NEW SEAT TRACK IAW SRM 51-42-11.SDR DALA14008983304Seat Track · corrodedSEAT TRACK Y 450 FOUND CORRODED FRAMES 56 - 58. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-00-15, FIG 102. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA14008973304Seat Track · corrodedSEAT TRACK Y-1959, FOUND CORRODED AT FRAME 53.1. REMOVED CORROSION IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11.
Back to N804NW