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 DALA2015032902461Connector · looseFOUND EMERGENCY LIGHT AT ROW 36 RT NOT ILLUMINATED. FOUND CONNECTOR CAME LOOSE, REINSTALLED, CHECKED OK.SDR DALA2014093005384Skin · scratchedAFT CARGO DOOR INTERIOR SURFACE FOUND SCRATCHED. DAMAGED AREA AT AFT CARGO DOOR TRIMMED OFF, NEW DOUBLER AND FILLER FABRICATED.SDR DALA2014082604759Wire · disconnectedEXIT LIGHT OVER DOOR 3R NEVER COMES ON. FOUND 2 WIRES DISCONNECTED. RE-CONNECTED WIRES.SDR DALA2014082604758Light · malfunctionedEXIT LIGHT OVER DOOR 2R AND 4R STAYS ON THROUGHOUT FLIGHT. CIDS RESET CARRIED OUT UNABLE TO FAULT ON GROUND.SDR DALA2014082604757Light · malfunctionedEMERGENCY EXIT SIGNS INOPERATIVE. EXIT LIGHT OVER DOOR 2R AND 4R STAYS ON THROUGHOUT FLIGHT. ALL LIGHTS OPERATE NORMAL ON GROUND, UNABLE TO FAULT.SDR DALA2014082504711Battery Pack · inoperativeFLASHLIGHT AT L3 DOOR NOT BLINKING. REPLACED BATTERY PACK.SDR DALA13012933301Seat Track · corrodedSEAT TRACK -Y953 CORRODED AT FR49, FR50, FR51, FR53. CORROSION REMOVED IAW SRM 51-74-00. FOUND OUT OF LIMIT IAW SRM 53-31-15 FIG 101. DAMAGED SEAT TRACK REMOVED AND REPAIRED IAW PRI 511271-14 REV 0.SDR DALA13012923301Seat Track · corrodedSEAT TRACK -Y450 CORRODED AT FR 49, FR50, FR51. CORROSION REMOVED IAW SRM 51-74-00. FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. DAMAGED SEAT TRACK REMOVED AND ACCOMPLISHED REPAIR IAW PRI 511271-14, REV O.SDR DALA13012403301Floor Support · corrodedLONGITUDINAL FLOOR SUPPORT AT Y1456 FR18 FOUND CORROSION. FLOOR SUPPORT R & R IAW PRI 511275-14, REV O.SDR DALA13012093301Seat Track · corrodedSEAT TRACK CORROSION FOUND AT Y2462, FR 56 AND FR 57.3. REPAIRED SEAT TRACK IAW ER/A 511271-14.SDR DALA13012083301Seat Track · corrodedDURING INSPECTION, SEAT TRACK CORROSION WAS FOUND AT Y953, FR 59, FR 60, AND FR 65 IAW ER/A 511271-14. REPLACED SEAT TRACK.SDR DALA13012073301Seat Track · corrodedSEAT TRACK CORROSION FOUND AT Y1959, FR40, FR44, AND FR 46. REPLACED SEAT TRACK IAW SRM 53-31-15, FIG 101 AND ER/A 511271-14.SDR DALA13010533301Seat Track · corrodedSEAT TRACK Y450 CORRODED AT FR4 9, FR50 AND FR51. CORROSION ON SEAT TRACK ZN 250 Y450 AT FR49, FR50 AND F R51 REMOVED SRM 51-74-00 AND FOUND OUT OF LIMITS SRM 53-31-15, FIG 101. SEAT TRACK. R & R IAW SRM 51-42-11.SDR DALA13010523301Seat Track · corrodedSEAT TRACK -Y2462 CORRODED AT F R52 AND FR53.2. CORROSION ON SEAT TRACK ZN 250 -Y2462 AT FR52 AND FR53. 2. REMOVED 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, SIN 347779.SDR DALA13010513301Seat Track · corrodedSEAT TRACK Y2462 CORRODED AT FR 48, FWD FR53.2. CORROSION ON SEAT TRACK ZN 250 Y2462 AT FR48 AND FR53.2. REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS SRM 53-31-15, FIG 101. SEAT TRACK R & R WITH A NEW SEAT TRACK IAW SRM 51-42-11. SIN 347779 6 MAR 2013.SDR DALA13010503301Seat Track · corrodedSEAT TRACK Y1959 CORRODED AT FR 48, FWD FR53.2. CORROSION ON SEAT TRACK ZN 250 Y1959 AT FR48 AND FR53.2, REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK R & R WITH A NEW SEAT TRACK SRM 51-42-11.SDR DALA13010493301Seat Track · corrodedSEAT TRACK -Y1959 CORRODED AT AFT FR49, FR53, FR53.2. CORROSION ON SEAT TRACK ZN 250 -Y1959 AT FR49, FR53 AND FR53.2. REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. CORRODED SEAT TRACK R & R WITH A NEW SEAT TRACK IAW SRM 51-42-11SDR DALA13010483301Seat Track · corrodedSEAT TRACK, Y953, CORRODED AT FR5 0, FR53. CORROSION ON SEAT TRACK ZN 250, Y953 AT FR50 AND FR53 REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. CORRODED SEAT TRACK R & R WITH A NEW SEAT TRACK IAW SRM 51-42-11.SDR DALA1010943301Unknown · leakingSUSPECTED FUEL LEAK FROM THE LT ENGINE AREA. THE FLT. CREW CONTACTED THE MCC AND REPORTED THAT THE LT FUEL QTY HAD DECREASED BY APPROX 4000LBS AND THAT AN ACFT BEHIND THEM HAD REPORTED THAT THEY HAD A MIST COMING FROM THE LT ENGINE AREA. THE CREW IS FOLLOWINSDR DALA105443301Seat Track · corrodedDURING "H" CHECK FOUND CORROSION ON SEAT TRACK AT -Y2462 FRAME FR54-FR55, FR57-FR58. REPLACED SEAT TRACK PER SRM 51-42-11.SDR NWAA094293301Battery Pack · inoperativeEPSU (14WL) FAILED TEST, REPLACED BATTERY AND TESTS OK.SDR NWAA092223301Battery Pack · unknownBATTERY EPSU (19WL) MESSAGE DURING TEST, REPLACED BATTERY AND TESTS OK.SDR NWAA091993301Skin · dentedDURING "H" CHECK, FOUND DENTS ON RT FUSELAGE SKIN AT FR 49 S25R-S26R. REPAIRED PER EA 33-216008.SDR NWAA092003301Seat Track · corrodedDURING "H" CHECK, FOUND CORROSION ON SEAT TRACK AT Y1456 FR 16A. REPAIRED PER EA 33-215997.SDR NWAA081313301Battery · dischargedTEST FAULTED EPSU BATTERY (12WL) DOOR NR 1. REPLACED BATTERY AND TESTED GOOD.SDR NWAA080273301Battery Pack · inoperativeCIDS 1 TEST OF EPSU FAILED, CARD 3351-7008 JOB 1-02, ATA 335100 BAT/EPSU (17WL) DOOR 4L. BATTERY PACK REPLACED.SDR NWAA073533301Rib · crackedDURING INSPECTION PER AD 2006-22-14, FOUND CRACK IN AFT TOP FASTENER HOLE OF WING RIB 6. REPAIRED PER EA 33-210974.SDR NWAA071933301Power Supply · no testCREW REST EPSU EMERGENCY POWER SUPPLY FAILED IT OPERATIONAL TEST, REMOVED AND REPLACED POWER PACK AND CHECKED GOOD.SDR NWAA071923301Power Supply · no testDOOR 2L EPSU EMERGENCY POWER SUPPLY FAILED IT OPERATIONAL TEST, REMOVED AND REPLACED POWER PACK AND CHECKED GOOD.SDR 0302193301Converter · failedELECTRICAL FUMES IN AREA OF DOOR 2R AND RIGHT HALF IFE SYSTEM FAILED. DEACTIVATED ENTIRE PASSENGER IFE SYSTEM AND FUMES/BURNING SMELL DISSIPATED. FLIGHT CONTINUED TO DTW AND LANDED WITHOUT INCIDENT. SEAT 12HJ PED SUPPLY SUSPECTED OF CAUSING FUMES. DEACTIVA
Back to N801NW