N801NW
Service difficulty reports · 280
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 = 'N801NW' 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 = 'N801NW' 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 DALA2020120804014Floor Support · corrodedCORROSION FLOOR BEAM -Y380 BETWEEN FR 75 TO FR 78 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM AND FASTENERS BETWEEN FR 75 TO FR 78 -Y380 AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120804013Floorbeam · corrodedCORROSION FLOOR BEAM -Y794.3 AT LEVEL FR 73 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y794.3 AT LEVEL FR 72 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120303962Seat Track · corrodedCORROSION SEAT TRACK -YA AT LEVEL FR 73A AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -YA LOCATED AT LEVEL FR 734 AT AFT GALLEY AREA, AS PER A330 SRM AND DRAWING.SDR DALA2020120303961Floor Support · corrodedCORROSION FLOOR BEAM -Y450 BETWEEN FR 72 TO FR 75 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y450 BETWEEN FR 72 TO FR 75 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120303963Seat Track · corrodedCORROSION SEAT TRACK YC1 BETWEEN FR 74 TO FR 75 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK AND FASTENER LOCATED YC1 BETWEEN FR 74 TO FR 75 AT AFT GALLEY AREA, AS PER A330 SRM AND DRAWING.SDR DALA2020120103932Seat Track · corrodedCORROSION SEAT TRACK -Y1556 LOCATED BETWEEN FRAME 32 TO FRAME 34 IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y1556 LOCATED BETWEEN FR 32 TO FR 34 IN PASSENGER CREW, AS PER SRM AND DWG.SDR DALA2020120103938Floorbeam · corrodedCORROSION FLOOR STRUCTURE AT FR 74 BETWEEN YA AND YB1 AT AFT GALLEY. CORRECTIVE ACTION: REPLACED FLOOR STRUCTURE LOC BETWEEN FR 73 TO FR 74 AND YA TO TB1 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120103937Seat Track · corrodedCORROSION SEAT TRACK YB1 BETWEEN FR 73/FR 74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK YBI LOCATED BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120103933Seat Track · corrodedCORROSION SEAT TRACK -YC BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -YC LOCATED BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120103936Seat Track · corrodedCORROSION SEAT TRACK -Y2462 LOCATED BETWEEN FRAME 30 TO FRAME 37. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y2462 LOCATED BETWEEN FRAME 30 TO FRAME 37, AS PER A330 SRM AND DRAWING.SDR DALA2020120103935Seat Track · corrodedCORROSION SEAT TRACK -YB BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -YB BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020120103934Seat Track · corrodedCORROSION SEAT TRACK -YB1 BETWEEN FR 73A/FR 74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK -YB1 BETWEEN FR 73 TO FR 74 AT AFT GALLEY AREA, AS PER A330 SRM AND DWG.SDR DALA2020113003921Seat Track · corrodedCORROSION SEAT TRACK -Y1959 BETWEEN FR 30 TO FR 37 IN PASSENGER CABIN. CORRECTIVE ACTION: REPLACED SEAT TRACK -Y1959 BETWEEN FR 30-10-FR 37 IN PASSENGER CABIN, AS PER A320 SRM AND DWG.SDR DALA2020010500055Seat Track · corrodedDURING C CHECK, SEAT TRACK AT FR 32, -Y2462 WAS FOUND CORRODED. REPLACED SEAT TRACK PER SRM 51-72-11.SDR DALA2020010500054Seat Track · corrodedDURING C CHECK, SEAT TRACK AT Y STATION UNDER FLOOR PANEL 241DF WAS FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-72-11.SDR DALA2020010500053Seat Track · corrodedDURING C CHECK, SEAT TRACK AT FR 35, Y1959 WAS FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-72-11.SDR DALA2020010500051Seat Track · corrodedDURING C CHECK, SEAT TRACK AT FR 37-37.1, Y1456 WAS FOUND CORRODED. REPAIRED SEAT TRACK PER ER/A 584254-14. LP 1429642SDR DALA2019120507095Connector · disconnectedEMERGENCY LIGHTS INOPERATIVE AT SEATS 3.J AND 41J. RE-CONNECTED CONNECTORS UNDER SEAT 30J AND 41J. LP 6453105SDR DALA2019011500265Cover · missingDURING PDC INSPECTION, FOUND LEFT FIXED NR 5 FLAP TRACK FAIRING LOWER COVER MISSING. REPLACED LEFT NR 5 FLAP TRACK CAP. LP 4980747SDR DALA2018111200330Epsu · inoperativeDURING SERVICE CHECK, FOUND EPSU FAILED EMERGENCY LIGHT CHECK. REPLACED EPSU.SDR DALA2018082805388Skin · gougedWHILE ON THE LINE IN CDG, MTC NOTED GOUGE DAMAGE TO THE AFT CARGO DOOR CUTOUT. THE SKIN FWD OF THE DOOR WAS GOUGED, AS WAS THE CONNECTING STRAP (REFERENCE FIGURES 1 AND 2 FOR DETAILS IN THE INSTRUCTIONS SECTION). THE DAMAGE IS LOCATED AT FRAME 59A AND STR 40R.SDR DALA2018022601190Sign · detachedL3 DOOR EXIT SIGN ASSEMBLY FELL OFF WALL, FOUND EXIT SIGN BROKEN. REPLACED THE SIGN.SDR DALA2018012400010Lens · looseEMERGENCY EXIT SIGN LENS LOOSE. INSTALLED THE EMERGENCY EXIT SIGN LENS.SDR DALA2017123109013Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE AT SEAT 29HJ-30HJ. REPLACED BATTERY PACK FROM CHARGER 16WL.SDR DALA2017120508420Switch · inoperativeEMERGENCY SEAT MOUNTED LIGHTING INOPERATIVE. RESET EMERGENCY LIGHT SWITCH. LP 0325520SDR DALA2017111308098Connector · disconnectedEMERGENCY LIGHTS AT SEATS 30 AND 31 RIGHT SIDE FOUND INOPERATIVE. CONNECTED THE CONNECTOR.SDR DALA2017110808004Battery Pack · no testASPSU BATTERY ONE TEST FAILED. REPLACED NBR 1 ASPSU BATTERY.SDR DALA2017082006321Connector · damagedSEVERAL ROWS OF EMERGENCY LIGHTS OUT ON RIGHT SIDE OF AIRCRAFT. RESEATED PIN IN CONNECTOR AT SEAT 23RH, REPLACED LIGHT ASSEMBLY AT SEAT 29RH, SWAPPED CONNECTOR WIRING AT SEAT 32RH, AND REPAIRED CONNECTOR WIRING AT SEAT 37R.SDR DALA2017082006320Connector · damagedSEVERAL ROWS OF EMERGENCY LIGHTS INOPERATIVE ON LEFT SIDE OF AIRCRAFT. RECONNECTED CONNECTOR AT SEAT 33LH, AND RESEATED PINS IN CONNECTOR 31LH, AND REPLACED BENT PIN IN SEAT ROW 30LH.SDR DALA2017031902321Light · missingFLOOR EMERGENCY LIGHT AT SEAT 42JH FOUND MISSING. REPLACED THE EMERGENCY LIGHT.SDR DALA2016100206980Epsu · faultyDURING FLIGHT COMPARTMENT HFA CHECK, FOUND EPSU 19WL AND 12WL FAULT. REPLACED EPSU 19WL AND 12WL EPSU BATTERY.SDR DALA2015122007677Power Supply · no testDURING EMERGENCY LIGHT TEST EPSU 13WL AND 16WL FAILED. REPLACED POWER SUPPLIES AND BATTERY PACKS.SDR DALA2015052903497Connector · damagedDURING M-CHECK, R3 DOOR SLIDE EPSU FAILED SYSTEM TEST 14WL AND 18WL. SECURED LOOSE PIN AT SLIDE LIGHT SWITCH AND REPLACED BATTERIES FOR 11 WL, AND 18 WL.SDR DALA2015052403456Floor Support · corrodedDURING M-CHECK, FOUND FRAME 75.5, Y1447.8 FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT. LP 1961307.SDR DALA2015052403455Floor Support · corrodedDURING M-CHECK, FOUND A FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT.SDR DALA2015051803309Floor Support · corrodedDURING M-CHECK, FOUND FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT.SDR DALA2015051803308Floor Support · corrodedDURING M-CHECK, FOUND FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT.SDR DALA2015051203203Seat Track · corrodedDURING M-CHECK, FOUND SEAT TRACK CORRODED AT FRAME 22, Y1959. MAINTENANCE REPLACED SEAT TRACK.SDR DALA2015051203202Seat Track · corrodedDURING M-CHECK FOUND SEAT TRACK CORRODED AT FR 33 -Y953. REPLACED SEAT TRACK.SDR DALA2015051103182Seat Track · corrodedDURING M-CHECK, FOUND SEAT TRACK CORRODED AT FRAME 35, Y2462. REPLACED THE SEAT TRACK.SDR DALA2015051103181Seat Track · corrodedDURING M-CHECK, FOUND SEAT TRACK CORRODED AT FRAME 35 Y1959. REPLACED THE SEAT TRACK.SDR DALA2015051103180Seat Track · corrodedDURING M-CHECK, SEAT TRACK FOUND CORRODED AT FRAMES 37.1 - 37.4 Y1959. REPLACED THE SEAT TRACK.SDR DALA2015051103179Seat Track · corrodedDURING M-CHECK, SEAT TRACK FOUND CORRODED FRAME 75.5, Y1478. REPLACED THE SEAT TRACK.SDR DALA2015051103178Seat Track · corrodedDURING M-CHECK, FOUND SEAT TRACK CORRODED AT FRAMES 37-39 Y 1959 IN MID CABIN. REPLACED THE SEAT TRACK.SDR DALA2015051103177Seat Track · corrodedDURING M-CHECK, SEAT TRACK FOUND CORRODED. REPLACED THE SEAT TRACK.SDR DALA2015051103176Floor Support · corrodedDURING M-CHECK, FLOOR SUPPORT FOUND CORRODED. REPLACED THE FLOOR SUPPORT.SDR DALA2015050603083Seat Track · corrodedSEAT TRACK FOUND CORRODED AT CABIN ZONE 270, C73-74,-YA. REPLACED SEAT TRACK.SDR DALA2015050603082Seat Track · corrodedSEAT TRACK FOUND CORRODED AT CABIN ZONE 270, C72-74 YA. REPLACED SEAT TRACK.SDR DALA2015050603081Seat Track · corrodedSEAT TRACK FOUND CORRODED AT AFT CABIN ZONE FR 72-74, YA. REPLACED SEAT TRACK.SDR DALA2015050603080Seat Track · corrodedSEAT TRACK FOUND CORRODED AT CABIN ZONE 23 C 26-27-Y1456. REPLACED SEAT TRACK.
Back to N801NW