AD 2012-21-06
Registered aircraft · 81
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:2012-21-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-06')
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:2012-21-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-21-06') 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.
N747AEAircraft Trust & Financing Corp Trustee · Wilmington, DEN753GSClaire Aviation Inc · Wilmington, DEN788JMHarmon Foods Inc · Springfield, ILN794SDSd Aviation LLC · Syracuse, KSN7PPLj1919 Leasing LLC · Dos Palos, CAN805KBDavid A Bush Inc · Hanford, CAN8104LTvpx Ars Inc Trustee · North Salt Lake, UTN8105VAircraft Guaranty Corp Trustee · Oklahoma City, OKN81437Solomon Mark Trustee · Wilmington, DEN828NCBank Of Utah Trustee · Salt Lake City, UTN84NEState Of Nebraska · Lincoln, NEN85FDWileman Bros & Elliott Inc · Cutler, CAN902KAValiair Lc Trustee · Casper, WYN904GTAircraft Trustee Services Inc Trustee · Dover, DEN904KSIntermountain Medical Transport LLC · Salt Lake City, UTN904MWTriple P Aviation LLC · Kalispell, MTN909SRRitch Air LLC · Visalia, CAN90CHUnit B LLC · Stillmore, GAN90HGIntermountain Medical Transport LLC · Salt Lake City, UTN90KOenovation LLC · Saint Helena, CAN90KPEvans Realty Inc · Auburn, ALN90LYRegistered aircraftN917PCChester Haven LLC · Chester, SCN921RAAviation Trust Co LLC Trustee · Oklahoma City, OKN929PInternational Air Services Inc Trustee · Carson City, NVN936KAMontana Aircraft Trust Inc Trustee · Bozeman, MTN943SDRigging Time Aviation LLC · Yadkinville, NCN95VBLj-2091 Inc Trustee · Wilmington, DEN96MBBorner Michael E Trustee · Easton, MDN97ESShiner Air LLC · Shiner, TXN980DWRaven Aviation LLC · Fresno, CA
Back to AD 2012-21-06