N812NW
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 = 'N812NW' 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 = 'N812NW' 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 DALA1219703312Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR50-FR53.1 Y-450. REPAIR SEAT TRACK AS PER SRM 51-42-11.SDR DALA1219693312Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40.1-FR47 Y-1959. REPAIR SEAT TRACK AS PER SRM 51-42-11.SDR DALA1219683312Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40.2-FR46 Y- 450. REPAIR SEAT TRACK AS PER SRM 51-42-11.SDR DALA1219673312Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR40.2-FR46 Y-450. REPAIR SEAT TRACK AS PER SRM 51-42-11.SDR DALA1219663312Seat Track · corrodedFOUND SEAT TRACK CORROSION OUT OF LIMITS AS PER SRM 53-31-15 FIG 101, FR48-FR53.1 Y-450. REPAIR SEAT TRACK AS PER SRM 51-42-11.SDR DALA1113043312Diaphragm · puncturedDURING LINE CHECK FOUND DOOR 1R ASSIST BOTTLE READS 0. FOUND DIAPHRAGM DISC PUNCTURED. REPLACED, OPS AND LEAK OK PER 52-10-00-600-802.SDR DALA1053413312O-Ring · leakingAFTER ENGINE START CREW EXPERIENCED A FUME EVENT, TOXIC ODOR OF SWEATY SOCKS INDICATING WET SEALS IN THE COMPRESSOR SECTION LEAKING OIL. NO OIL LEAKS WERE FOUND IN THE ENGINE OR AIR-CONDITIONING SYS. NR 2 ENGINE START AND OIL ODOR, REPLACED DAMAGED OIL CAP OSDR DALA1032663312Oven · malfunctionedOVEN NR 2 IN GALLEY NR 1 HAD SMOKE AND SPARKS COMING OUT, CIRCUIT BREAKER WAS PULLED AND LANDING WAS UNEVENTFUL. OVEN REPLACED AND CHECKED OK. (2010-00859)SDR DALA102523312Oven · smokeOVEN NR 3 HAD SMOKE COMING OUT, CIRCUIT BREAKER WAS PULLED AND LANDING WAS UNEVENTFUL. OVEN REPLACED AND CHECKED OK.SDR NWAA083333312Structure · dentedDURING LINE CHECK FOUND DENT ON INSIDE OF AFT CARGO DOOR. INTERIM REPAIR ACCOMPLISHED PER EA 33-213392 SECT I, SECT II PERMANENT REPAIR TO BE ACCOMPLISHED NEXT "L" CHECK AFTER 05 JUL 08. (S)
Back to N812NW