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 DALA14008963304Seat Track · corrodedSEAT TRACK Y-2462, FOUND CORRODED AT FRAME 63. 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 DALA14008953304Seat Track · corrodedSEAT TRACK Y-450, FOUND CORRODED AT FRAME 53.3. 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.SDR DALA14008943304Seat Track · corrodedSEAT TRACK Y=2462 FOUND CORRODED AT FRAME 56. REMOVED CORROSION IAW SRM 51-74-11 AND FOUND OUT OF LIMITS IAW SRM 53-00-15 FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA14008933304Seat Track · corrodedSEAT TRACK FRAMES 75 - 76 FOUND CORRODED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG 103. REMOVED & REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR DALA14008833304Seat Track · corrodedSEAT TRACK -450 FOUND CORRODED FRAME 37.3-37.4. 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.SDR DALA14008823304Seat Track · corrodedSEAT TRACK -2462, FOUND CORRODED FRAME 39 -39.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.SDR DALA14008813304Seat Track · corrodedSEAT TRACK -2462, FOUND CORRODED FRAMES 37.2 - 37.3. 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.SDR DALA13038893304Battery · no testFOUR EMERGENCY LIGHT BATTERIES FAILED TEST. R & R BATTERIES IAW AMM 33-51. CHECKED GOOD.SDR DALA1211143304Liner · damagedFOUND AFT CARGO EXTERNAL LOWER LINING 822BR EDGE DAMAGED. REPAIRED AS PER SRM 52-32-00 FIG 210. DAMAGE LENGTH 2 INCHES BY 5 INCHES WIDE.SDR DALA1155643304Epsu · faultedWHILE PERFORMING EMERGENCY LIGHT TEST FAULTED EPSU (14WL). MAINTENANCE REPLACED EPSU AND THEN THE SYSTEM TESTED OK.SDR DALA106693304Battery Pack · no testBATTERY EPSU (17WL) DOOR 4 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR DALA106683304Battery Pack · no testBATTERY EPSU (13WL) DOOR 2 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR DALA106673304Battery Pack · inoperativeBATTERY EPSU (16WL) DOOR 3 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR DALA106663304Battery Pack · no testBATTERY EPSU (12WL) DOOR 1 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR DALA106653304Battery Pack · inoperativeBATTERY EPSU (11WL) DOOR 1 FAILED SYSTEM CHECK, REPLACED BATTERY AND TESTS OK.SDR DALA106643304Battery Pack · failedBATTERY EPSU (15WL) DOOR 3 FAILED SYS CHECK, REPLACED BATTERY AND TESTS, OK.SDR DALA103983304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y953 FR17. REPAIRED IAW ERA 479515-14.SDR DALA103973304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR32-34. REPLACED SEAT TRACK IAW ERA 479526-14.SDR DALA103963304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT -Y2462 FR35. REPLACED SEAT TRACK IAW ERA 479526-14.SDR DALA103953304Floor Support · corrodedDURING "H" CHECK FOUND CORROSION ON FLOOR PANEL SUPPORT AT Y2462 FR35. REPAIRED ERA 14-479526.SDR DALA103943304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y953 FR37. REPLACED SEAT TRACK IAW ERA 479526-14.SDR DALA103933304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT -Y450 FR53. REPLACED SEAT TRACK IAW SRM 51-42-11 AND ERA 479517-14.SDR DALA103923304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK ON Y450 FR47. REPAIRED IAW SRM 51-42-11.SDR DALA103793304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y450 CORRODED AT FR59-FR67. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 019-260.SDR DALA103783304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT -Y450 FR44. REPLACED SEAT TRACK IAW SRM 51-74-00, AND SRM 53-00-15.SDR DALA103613304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 57. REPAIRED IAW SRM 51-42-11.SDR DALA103603304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR 58. REPAIRED IAW SRM 51-42-11.SDR DALA103593304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y2462 FR 65. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA103313304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR52. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 015-250.SDR DALA103303304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR50. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 028-250.SDR DALA103293304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR49. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 028-250.SDR DALA103283304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR48. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 028-250.SDR DALA103263304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR44. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-250.SDR DALA103273304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR45. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-250.SDR DALA103253304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR42. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-250.SDR DALA103403304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-2462 CORRODED AT FR70. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 046/260.SDR DALA103393304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-2462 CORRODED AT FR71. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 040/260.SDR DALA103383304Seat Track · corrodedDURING (H) CHECK FOUND SEAT TRACK Y-1436 CORRODED AT FR19, AND FR20. REPAIRED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15.SDR DALA103373304Seat Track · corrodedDURING H-CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR67. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-260.SDR DALA103363304Seat Track · corrodedDURING H-CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR66. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-260.SDR DALA103353304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR62. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024-260.SDR DALA103343304Seat Track · corrodedDURING H CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR60. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-24-00, AND SRM 53-00-15, ON NRC 024-260.SDR DALA103333304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-405 CORRODED AT FR59. REPLACED SEAT TRACK. WORK ACCOMPLISHED IAW SRM 51-74-00, AND SRM 53-00-15, ON NRC 024/260.SDR DALA103323304Seat Track · corrodedDURING "H" CHECK FOUND SEAT TRACK Y-450 CORRODED AT FR54. REPLACED SEAT TRACK IAW SRM 51-74-00, AND SRM 53-31-15, ON NRC 001/260.SDR DALA103203304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR70. REPAIRED IAW SRM 51-42-11.SDR DALA103193304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR67. REPAIRED IAW SRM 53-42-11.SDR DALA103183304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR64. REPAIRED IAW SRM 51-42-11.SDR DALA103173304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR62. REPAIRED IAW SRM 51-42-11.SDR DALA103163304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR60. REPAIRED IAW SRM 51-42-11.SDR DALA103153304Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT Y1959 FR57. REPAIRED IAW SRM 51-42-11.
Back to N804NW