AD 2017-24-03
Registered aircraft · 937
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2017-24-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-24-03')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2017-24-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-24-03') ORDER BY n_number
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.
N129AABank Of Utah Trustee · Salt Lake City, UTN130ANBank Of Utah Trustee · Salt Lake City, UTN131NNBank Of Utah Trustee · Salt Lake City, UTN132ANBank Of Utah Trustee · Salt Lake City, UTN133ANBank Of Utah Trustee · Salt Lake City, UTN134ANBank Of Utah Trustee · Salt Lake City, UTN135NNAmerican Airlines Inc · Fort Worth, TXN136ANAmerican Airlines Inc · Fort Worth, TXN137AAAmerican Airlines Inc · Fort Worth, TXN138ANAmerican Airlines Inc · Fort Worth, TXN139ANAmerican Airlines Inc · Fort Worth, TXN140ANAmerican Airlines Inc · Fort Worth, TXN141NNAmerican Airlines Inc · Fort Worth, TXN142ANAmerican Airlines Inc · Fort Worth, TXN1438Bank Of Utah Trustee · Salt Lake City, UTN143ANAmerican Airlines Inc · Fort Worth, TXN144ANAmerican Airlines Inc · Fort Worth, TXN145ANAmerican Airlines Inc · Fort Worth, TXN146AAAmerican Airlines Inc · Fort Worth, TXN147AAAmerican Airlines Inc · Fort Worth, TXN148ANAmerican Airlines Inc · Fort Worth, TXN149ANAmerican Airlines Inc · Fort Worth, TXN150NNAmerican Airlines Inc · Fort Worth, TXN151ANAmerican Airlines Inc · Fort Worth, TXN152AAAmerican Airlines Inc · Fort Worth, TXN153ANAmerican Airlines Inc · Fort Worth, TXN154AAAmerican Airlines Inc · Fort Worth, TXN155NNAmerican Airlines Inc · Fort Worth, TXN156ANAmerican Airlines Inc · Fort Worth, TXN157AAAmerican Airlines Inc · Fort Worth, TXN158ANAmerican Airlines Inc · Fort Worth, TXN158ASAersale Inc · Coral Gables, FLN159ANAmerican Airlines Inc · Fort Worth, TXN160ANAmerican Airlines Inc · Fort Worth, TXN161AAAmerican Airlines Inc · Fort Worth, TXN162AAAmerican Airlines Inc · Fort Worth, TXN163AAAmerican Airlines Inc · Fort Worth, TXN164NNAmerican Airlines Inc · Fort Worth, TXN165NNAmerican Airlines Inc · Fort Worth, TXN166NNAmerican Airlines Inc · Fort Worth, TXN167ANAmerican Airlines Inc · Fort Worth, TXN188NVAllegiant Air LLC · Las Vegas, NVN189NVSunrise Asset Management LLC · Las Vegas, NVN1902UUnited Airlines Inc · Chicago, ILN190NVAllegiant Air LLC · Las Vegas, NVN1914UUnited Airlines Inc · Chicago, ILN191NVAllegiant Air LLC · Las Vegas, NVN192NVAllegiant Air LLC · Las Vegas, NVN193NVAllegiant Air LLC · Las Vegas, NVN194NVAllegiant Air LLC · Las Vegas, NV
Back to AD 2017-24-03