N815NW
Service difficulty reports · 242
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 = 'N815NW' 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 = 'N815NW' 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 DALA14026803315Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 60-61, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026893315Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 65-68, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026723315Seat Track · corrodedSEAT TRACK, -Y1456, FRAMES 22-24, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026713315Seat Track · corrodedSEAT TRACK Y400, FRAME 78, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026703315Seat Track · corrodedSEAT TRACK, RT Z-PROFILE FRAME 80 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026693315Seat Track · corrodedSEAT TRACK, Y400, FRAME 78 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-41-14.SDR DALA14026683315Seat Track · corrodedSEAT TRACK YA FRAME 80, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026673315Seat Track · corrodedSEAT TRACK YA FRAME 76, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026663315Seat Track · corrodedSEAT TRACK YA FRAME 73, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026633315Seat Track · corrodedSEAT TRACK Y450, FRAME 37.2-37.4. FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026623315Seat Track · corrodedSEAT TRACK -Y1959, FRAMES 66-69 CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026613315Seat Track · corrodedSEAT TRACK -Y450, FR 72-73 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026883315Seat Track · corrodedSEAT TRACK Y2462, FRAMES 40.1-44, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026773315Seat Track · corrodedSEAT TRACK, Y2462, FRAMES 48-53, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 52-41-11.SDR DALA14026743315Seat Track · corrodedSEAT TRACK -Y2462, FR 40.2-45. FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026733315Seat Track · corrodedSEAT TRACK Y450, FRAMES 40.1-43 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026643315Seat Track · corrodedSEAT TRACK -Y1456, FRAME 39.1 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026603315Seat Track · corrodedSEAT TRACK Y1959, FRAMES 41-45, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026553315Seat Track · corrodedSEAT TRACK, Y1959, FRAMES 50-53.1, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026543315Seat Track · corrodedSEAT TRACK -Y2462, FRAMES 47-52 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-31-15.SDR DALA14026763315Seat Track · corrodedSEAT TRACK -Y2452, FRAME 53.3-53.9. FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026593315Seat Track · corrodedSEAT TRACK -Y450, FRAMES 41-43, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026583315Seat Track · corrodedSEAT TRACK -Y1959, FRAMES 32-35 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026573315Seat Track · corrodedSEAT TRACK Y450, FRAME 53.9. FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-42-11.SDR DALA14026563315Seat Track · corrodedSEAT TRACK -Y1959, FRAMES 59-60, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026523315Seat Track · corrodedSEAT TRACK -Y450 FRAME 39 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026903315Battery Pack · inoperativeDURING BITE TEST OF ASPSU FOUND TEST RESULT FAULTED BATTERY 1. REPLACED BATTERY EMERGENCY LIGHT PACK OF ASPUS BATTERY 1.SDR DALA14026753315Seat Track · corrodedSEAT TRACK Y1959, FRAME 39.1, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026653315Seat Track · corrodedSEAT TRACK -Y1959, FRAME 16A FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026513315Seat Track · corrodedSEAT TRACK -Y953, FRAMES 38-5 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA14026873315Seat Track · corrodedSEAT TRACK Y450, FRAMES 72-74, FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 53-00-15.SDR DALA14026533315Seat Track · corrodedSEAT TRACK Y1959, FRAMES 62-67 FOUND CORRODED. REPLACED SEAT TRACK IAW SRM 51-74-00.SDR DALA13019983315Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE. SWITCHED ACFT NETWORK POWER SOURCES THEN ALL OK.SDR DALA12009983315Access Panel · chafedFOUND FWD CARGO DOOR, LOWER FWD ACCESS PANEL NR 821AR CHAFING. FOUND OUT OF LIMITS IAW SRM 52-31-00, FIG 105. REPAIR CARRIED OUT IAW SRM 52-31-00, FIG 211.SDR DALA12009333315Seat Track · corrodedFOUND SEAT TRACK CORRSION AT ZN 260, Y1959 FR53.5. CORRSION OUT OF LIMITS IAW SRM 53-31-15, FIG 101. REPAIR CARRIED OUT IAW SRM 53-31-15, FIG 201.SDR DALA12009973315Seat Track · corrodedFOUND CORROSION ON SEAT TRACK Y2462, FR47-FR53.2. FOUND CORROSION TO BE OUT OF LIMITS IAW SRM 53-31-15, FIG 101. REPLACED IAW SRM 51-42-11, DWG F53312958.SDR DALA12008803315Seat Track · corrodedFOUND SEAT TRACK CORRODED, Y450, FR48, FR52. FOUND TO BE OUT OF LIMITS IAW SRM 53-31-15, FIG 101.SDR DALA12008783315Seat Track · corrodedFOUND SEAT TRACK CORRODED, Y1959 FR53. FOUND OUT OF LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA12008793315Seat Track · corrodedFOUND SEAT TRACK CORRODED, Y450 FR 50-53.1. FOUND TO BE OUT OF LIMITS IAW SRM 53-31-15, FIG 101. SEAT TRACK REPLACED IAW SRM 51-42-11.SDR DALA12009483315Seat Track · corrodedFOUND CORROSION ON SEAT TRACK, ZONE 260, Y2462 FR58. CORROSION FOUND OUT OF LIMITS IAW SRM 53-00-15 FIG 102. REPLACEMENT CARRIED OUT IAW SRM51-42-11, DWG F53476210.SDR DALA12009343315Seat Track · corrodedFOUND SEAT TRACK CORROSION AT ZN260, Y1959, FR57.2. CORRSION WAS OUT OF LIMITS IAW SRM 53-0015, FIG 102. REPAIR IAW 51-42-11.SDR DALA1166653315Battery Pack · dischargedLOWER CREW REST FAILED EMERGENCY LIGHT TEST. REPLACED BATTERY PACK AS PER AMM33-55. OPS CHECK GOOD. 2011-00743.
Back to N815NW