N813NW
Service difficulty reports · 261
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 = 'N813NW' 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 = 'N813NW' 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 DALA1215273313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-00-15 FIG 101, FR57.4-FR58 Y-1959. REPAIR SEAT TRACK AS PER SRM 53-00-15 FIG 204.SDR DALA1215263313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR47-FR53 Y-1959. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1215253313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-47 Y-450. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1215243313Seat Track · corroded(LOG 0438901) FOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM53-31-15 FIG 101, FR48-53.2 Y-450. REPLACED SEAT TRACK AS PER SRM51-42-11.SDR DALA1215233313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-53.2 Y- 450. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1215223313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM53-31-15 FIG 101, FR40-40.3 Y-450. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1215213313Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-47 Y-1959. REPLACED SEAT TRACK AS PER SRM 51-42-11.SDR DALA1137743313Epsu · failedEMERGENCY LIGHT EPSU (13WL) DOOR 2 FAILED SYSTEM CHECK. REPLACED EPSU AND TESTS OK.SDR NWAA 091473313Battery Pack · malfunctionedEPSU FAULT (18WL), REPLACED BATTERY PACK (18WL) AND CHECKS GOOD.SDR NWAA082093313Oven · smokeAFTER TAKEOFF, SMOKE STARTED COMING OUT OF THE OVEN. LANDING WAS UNEVENTFUL AND OVEN WAS REPLACED.SDR NWAA081833313Battery Pack · inoperativeEPSU FAULT (18WL), REPLACED BATTERY PACK (18WL) AND CHECKS GOOD.
Back to N813NW