N859NW
Service difficulty reports · 260
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 = 'N859NW' 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 = 'N859NW' 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 DALA1208123359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-FR53 Y-450. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 3.SDR DALA1208113359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-FR47 Y-1959. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 2.SDR DALA1208163359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-FR47 Y- 450. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 2.SDR DALA1208153359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40-FR47 Y-450. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 2.SDR DALA1208143359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101 FR47-FR53.1 Y-1959. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 3.SDR DALA1208133359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR47-FR53.2 Y-2462. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 3.SDR DALA1208083359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-FR49 Y-450. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 3.SDR DALA1208073359Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR43-FR47 Y-1959. REPAIR SEAT TRACK AS PER SRM 53-31-15 FIG 2.SDR DALA10256863359Monitor · smokePILOT REPORTED IFE VIDEO MONITOR AT SEAT 13B HAD SMOKE COMING OUT OF IT. CHECKED ALL RELATED WIRES FOR BURNING OR DAMAGE AND ALL CHECKED OK, REPLACED MONITOR AND TESTS OK.SDR NWAA082373359Brake Assy · fireON ARRIVAL AT GATE, FOUND NR 1 BRAKE ON FIRE, A GROUND FIRE EXTINGUISHER WAS USED TO PUT OUT THE FIRE. THE BRAKE AND WHEEL WERE REPLACED AND CHECK OK.
Back to N859NW