N218NV
Service difficulty reports · 53
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 = 'N218NV' 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 = 'N218NV' 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 WX0A2015051172589Screen · dirtyLAVATORY SMOKE ALARM WENT OFF DURING OUR DESCENT. CHECKED LAVATORY SMOKE DETECTORS & CLEANED DUST FROM SCREENS. PERFORMED A CIDS BITE TEST. OPERATIONS CHECKED NORMAL IAW AMM 26-17-00.SDR WX0A2015040872514Guide Vane · damagedOGV AT 5:30 POSITION ENG 1. DAMAGE BEYOND LIMITS. R & R OGV AT THE 5:30 O CLOCK POSITION ON ENG NR 1 IAW AMM 72-23-00. NO DEFECTS NOTED.SDR WX0A2015022072423Light · inoperativeSEVERAL BULBS BURNED OUT ON EMER EXIT LOCATION SIGNS AT L1, L2, R1 & R2 DOORS. RELAMPED EMER EXIT LOCATION SIGNS AT L1, L2, R1 & R2 DOORS IAW MM 33-51-11. OPERATIONS CHECKED GOOD.
Back to N218NV