N811NW
Service difficulty reports · 305
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 = 'N811NW' 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 = 'N811NW' 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 DALA2017041803200Seat Track · corrodedY450, FRAMES 37 - 37.1 SEAT TRACK FOUND CORRODED. REPLACED THE SEAT TRACK.SDR DALA2017041803199Seat Track · corrodedCOORODED SEAT TRACK FRAMES 34 - 37, Y450. REPLACED THE SEAT TRACK.SDR DALA2017041700153Seat Track · corrodedMID CABIN, FRAMES 33-35, YZ462 SEAT TRACK FOUND CORRODED. THE SEAT TRACK WAS REPLACED.SDR DALA2017041700152Seat Track · corrodedAFT CABIN, FRAMES 73 - 74, -YC1 SEAT TRACK FOUND CORRODED. REPLACED THE SEAT TRACK.SDR DALA2017041700151Seat Track · corrodedAFT CABIN, FRAMES 73 - 74, -YC1 SEAT TRACK FOUND CORRODED. REPLACED THE SEAT TRACK.SDR DALA2017041403021Seat Track · corrodedDURING M CHECK, FOUND SEAT TRACK AT FR 14C - 16, -Y953 CORRODED. REPLACED THE SEAT TRACK SRM 51-42-11.SDR DALA2017041303020Flap Track · corrodedDURING M CHECK, FOUND CORROSION ON LEFT WING, NR 3 FLAP TRACK. REPLACED THE FLAP TRACK IAW SRM 27-54-57-000/400-801-A.SDR DALA2017041303019Flap Track · corrodedDURING M CHECK, FOUND CORROSION ON LEFT WING, NR 4 FLAP TRACK. REPLACED THE FLAP TRACK IAW SRM 27-54-57-000/400-801-A.SDR DALA2017041303018Flap Track · corrodedDURING M CHECK, FOUND CORROSION ON THE RIGHT WING, NR 3 FLAP TRACK. REPLACED THE FLAP TRACK IAW SRM 27-54-57-000/400-801-A.SDR DALA2022012500502None · noneSHIP 3311 FWD WASTE EXHAUST VENT CUTOUT FOUND CORROSION. CORRECTIVE ACTION: FUSELAGE SKIN WAS REMOVED BY SMOOTHING OUT AS PER A330 SRM51-73-00. THE FASTENERS AROUND REWORK AREA WERE REMOVED AND REINSTALLED AS PER A330 SRM 51-42-11. PERFORMED HFEC INSPECTION ONSDR DALA2017021700030Battery Pack · no testDURING EPSU BATTERY CAPACITY CHECK, THE BATTERY PACKS FAILED. REPLACED THE BATTERY PACKS.SDR DALA2017010500121Light · damagedDURING INSPECTION, FOUND GALLEY A1, LEFT EEPL 97WL DAMAGED. REPLACED EEPL 97WL AND RE-ATTACHED EMERGENCY ESCAPE PATH MARKER LIGHT ASSEMBLY.SDR DALA2021032601801Skin · dentedSHIP 3311 DENT NEAR AFT LAV SVC PANEL BETWEEN STRINGERS 47L AND 47L AND FRAMES 72 & 73. CORRECTIVE ACTION: PERFORMED PERMANENT REPAIR ON LOWER EXTERNAL SKIN PER A330 SRM 53-41. (9046636)SDR DALA2016041102886Contact · failedDOOR 2L AND 3L EMERGENCY LIGHTS, ONE LED LIGHT INTERMITTENTLY WORKING. REPLACED BAD CONTACT.SDR DALA2015083105331Battery Pack · faultedDURING OPS CHECK OF EMERGENCY LIGHTS, FOUND BATTERY FAULTED. REPLACED BATTERY PACK.SDR DALA2015080404790Battery Pack · no testDURING EMERGENCY LIGHT TEST, BATTERY EPSU 15WL FAILED AT R3 DOOR AND LT ESCAPE SLIDE EPSU 19WL. REPLACED BATTERY PACK AT 19WC IAW AMM 33-51.SDR DALA2015061103698Battery Pack · inoperativeDURING EMERGENCY SYSTEM CHECK FOUR EPSU AT 19WL INOPERATIVE. REPLACED EPSU AND BATTERY AT 19WL. LP 7027118.SDR DALA2015051003175Power Supply · faultedDURING EPSU SYSTEM TEST, FOUND L3 DOOR BATTERY FAULTED. REPLACED THE POWER SUPPLY.SDR DALA2014080604323O-Ring · leakingLOSS OF GREEN SYS HYDRAULIC FLUID. ALTERNATE GEAR EXTENDED. REPLACED GREEN SYS BRAKE MANIFOLD O-RING SEAL.SDR DALA13055513311Seat Track · corrodedSEAT TRACK Y2462, FRAMES 56 AND 58 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS SRM 53-00-15, FIG 102. SEAT TRACK REMOVED IAW SRM 51-42-11. NEW SEAT TRACK REWORKED IAW DWG F53476210 AND INSTALLED IAW SRM 51-42-11.SDR DALA13055503311Seat Track · corrodedSEAT TRACK Y2462, FRAMES 53.3, 53.9 AND 54 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055493311Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 62, 65 AND 69 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102 . SEAT TRACK R & R IAW SRM 51-42- 11.SDR DALA13055483311Seat Track · corrodedSEAT TRACK Y953 FRAMES 59, 61 AND 64 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055473311Seat Track · corrodedSEAT TRACK Y1959, FRAMES 56, 57.3 AND 58 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51- 42-11.SDR DALA13055463311Seat Track · corrodedSEAT TRACK Y1959, FRAMES 63, 68 AND 71 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 10 2. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055453311Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 53.3, 53.8 AND 54 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-31- 15, FIG 101. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055443311Seat Track · corrodedSEAT TRACK -Y1959 FRAMES 62, 66 AND 68 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 1 02. SEAT TRACK R & R IAW SRM 51-4 2-11.SDR DALA13055213311Seat Track · corrodedSEAT TRACK -Y953, FRAMES 53.8, 53.9 AND 54 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055203311Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 56, 57.1 AND 58 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055193311Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 59 - 61 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-0 0-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055183311Seat Track · corrodedSEAT TRACK Y1959, FRAMES 60 - 61 CORRODED, CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055173311Seat Track · corrodedSEAT TRACK -Y1959 FRAMES 53.3 - 53.7 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK, R & R IAW SRM 51-42-11.SDR DALA13055163311Seat Track · corrodedSEAT TRACK Y953, FRAMES 56 - 57.4 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-0 0-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055153311Seat Track · corrodedSEAT TRACK Y450, FRAMES 53.6 - 54 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK R & R SRM 51-42-11.SDR DALA13055143311Seat Track · corrodedSEAT TRACK Y450, FRAME 72 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055133311Seat Track · corrodedSEAT TRACK FRAME 73 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53 -00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055123311Seat Track · corrodedSEAT TRACK FOUND CORRODED FRAMES 68 - 71. CORROSION REMOVED SRM 51-74-00. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055113311Seat Track · corrodedSEAT TRACK FOUND CORRODED Y450 FRAMES 66 - 71. CORROSION REMOVED 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 DALA13055103311Seat Track · corrodedSEAT TRACK FOUND CORRODED FRAMES 61 - 66. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK REMOVED IAW SRM 51-42-11. NEW SEAT TRACK REWORKED IAW DWG F53477214 AND INSTALLED IAW SRM 51-42-11.SDR DALA13055093311Seat Track · corrodedSEAT TRACK FOUND CORRODED FRAMES 55 - 57.2. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13055083311Seat Track · corrodedSEAT TRACK FOUND CORROED FRAMES 59 - 66. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND EXCEED LIMITS IAW SRM 53-00-15, FIG 102. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13054223311Seat Track · corrodedSEAT TRACK Y2462 FRAMES 47, 50 AND 53.1 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA13054213311Seat Track · corrodedSEAT TRACK Y2462 FRAMES 50, 53 AND 53.1 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA13054203311Seat Track · corrodedSEAT TRACK -Y1959, FRAMES 47 & 53.1 CORROED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA13054193311Seat Track · corrodedSEAT TRACK -Y953 FRAMES 47-51 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA13054183311Seat Track · corrodedSEAT TRACK, -Y953 FRAMES 47- 51 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. R & R SEAT TRACK IAW SRM 51-42-11.SDR DALA13054173311Seat Track · corrodedSEAT TRACK, Y-450, FRAME 53 CORRODED. CORROSION REMOVED IAW SRM 51-74-00 AND FOUND OUT OF LIMIT IAW SRM 53-31-15, FIG 101. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA13044383311Battery Pack · faultedEMERGENCY LIGHT BATTERY PACK 18WL FAULTED. REPLACED BATTERY PACK IAW AMM 33-51. TESTED GOOD.SDR DALA1228493311Power Supply · no testDOOR NR 4 LEFT EMERGENCY POWER SUPPLY FAILED TEST (17WL). REPLACED EPSU 17WL, OPS CHECKED GOOD.SDR DALA1167723311Battery Pack · failedDURING EMERGENCY LIGHT TEST FOUND DR 3LE 15WL BATTERY PACK FAILED TEST. REPLACED BATTERY PACK 15WL, OPS CHECK GOOD.
Back to N811NW