N817NW
Service difficulty reports · 221
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 = 'N817NW' 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 = 'N817NW' 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 DALA2017082800002Light · inoperativeEMERGENCY EXIT LIGHT INOP AT DOOR 4R INOPERATIVE. RE-FITTED EMERGENCY LIGHT COVER AND TESTED FOR CORRECT OPERATIONAL.SDR DALA2017081606261Switch · malfunctionedEMERGENCY LIGHTS AT THE L2 & 3 DOORS WOULD NOT EXTINGUISH DURING FLIGHT. CYCLED EMERGENCY LIGHT SWITCH, OPERATIONAL CHECKED OK.SDR DALA2017052404154Cover · looseEMERGENCY EXIT SIGN COVER AT L3 DOOR LOOSE. SECURED EMERGENCY SIGN EXIT COVER.SDR DALA2017033002621Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. RE-INSTALLED EMERGENCY EXIT COVER DIFFUSER LENS.SDR DALA2016100407055Slide · failedDURING L2 CHECK, EPSU SYSTEM TEST FOUND FAULT MESSAGE: ESCAPE SLIDE SW/EPSU 13WL AT DOOR 2L. REPLACED SLIDE AT DOOR 2L.SDR DALA2016100407054Skin · dentedDURING WALK AROUND, FOUND A DENT ON THE RIGHT OUTBOARD SLAT. REPAIRED IAW SRM 57-40-00 PARA 5.C AND FIG 203.SDR DALA2016060604376Light · inoperativeEMERGENCY LIGHTS FROM SEAT ROW 15HJ TO 28HJ ON WHILE EMERGENCY POWER SWITCH IN ARMED POSITION AND POWER AVAILABLE. FOUND SECTION OF LIGHTS ON ONLY WHEN NO SMOKING SWITCHED TO AUTO OR ON WITH EMERGENCY LIGHT SWITCH IN ARMED POSITION. RESET AND RECONNECTED DOOSDR DALA2015111206913Power Supply · no testDOOR 4R EMERGENCY LIGHT POWER SUPPLY FAILED TEST. REPLACED THE POWER SUPPLY.SDR DALA2014122206632Connector · disconnectedSEAT MOUNTED EMERGENCY LIGHT INOPERATIVE AT SEAT 27. CONNECTED WIRE HARESS CONNECTOR.SDR DALA13062683317Seat Track · corrodedSEAT TRACK Y-1959 FRAME 53.1 FOUND CORRODED. CORROSION REMOVED IAW SRM 51-74-00 REV 79. FOUND OUT OF LIMITS IAW SRM 53-31-15 FIG 101 REV 79. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-42-1 1 REV 79.SDR DALA13062673317Seat Track · corrodedSEAT TRACK Y450 FRAME 53 FOUND CORRODED. CORROSION REMOVED IAW SRM 51-74-00 REV 79.00. FOUND OUT OF LIMITS IAW SRM 53-31-15 FIG 101 RE V 79. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-42- 11 REV 79.SDR DALA13004713317Seat Track · corrodedCABIN - ZONE 220, SEAT TRACK -Y953 CORRODED AT FR16A, FR15C CORR. SEAT TRACK -Y953 AT FR16A AND FR15C. REMOVED IAW SRM 51-74-00 FOUND EXCEED LIMITS IAW SRM 53-11-15, FIG 101. FR15C MATERIAL REMOVED:0.041", L=1"XW=0.5", FR16A MATERIAL REMOVED:0.040", L=1.5,W=0SDR DALA13004363317Skin · dentedL4 DOOR SKIN EXTERNAL LOWER EDGE FOUND DENTED. REPAIRED IAW SRM 52-13-00.SDR DALA13004353317Web · dentedAFT CARGO DOOR INTERIOR LOWER WEB BETWEEN FR63 AND FR63A FOUND DENT. AFT CARGO DOOR INTERIOR LOWER WEB BETWEEN FR 63 AND FR6 3A FOUND DENT DAMAGED AND REPAIR TO BE CARRY OUT IAW PRI 51062 3-14.SDR DALA13003983317Seat Track · corrodedSEAT TRACK FROM FR47 TO FR35.2, -Y2462 FOUND CORRODED. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13003973317Seat Track · corrodedSEAT TRACK, Y450 CORRODED AT FR50 & FR53. SEAT TRAC R & R IAW SRM 51-42-11.SDR DALA13003963317Seat Track · corrodedSEAT TRACK -Y450 CORRODED AT FR50 & FR51. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13003953317Seat Track · corrodedSEAT TRACK FROM FR47-FR53.2, -Y1959 FOUND CORRODED. SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13003943317Seat Track · corrodedSEAT TRACK Y1959 CORRODED AT FWD FR50 & FR53.1. CORRODED SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13003933317Seat Track · corrodedSEAT TRACK Y2462 CORRODED AT FWD FR53 & 53.1. CORRODED SEAT TRACK R & R IAW SRM 51-42-11.SDR DALA13003923317Seat Track · corrodedSEAT TRACK -Y953 CORRODED AT FWD FR53.4 & FR54. CORRODED SEAT TRACK REPAIRED IAW SRM 53-31-15, FIG 201.
Back to N817NW