AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N5509BKorn Antony · Chehalis, WAN550BNAllen Anne · Huntsville, TXN550CERobinson James K · Eagle, IDN550JBBowley John P · Middletown, NYN550JSBawk Aviation LLC · Xenia, OHN550MGGriggs Matthew J · Tunkhannock, PAN550MTLiving Sky Grains LLC · Three Forks, MTN550NVHoffman Andrew Todd · Mound House, NVN550PJPeterson Todd · El Dorado, KSN550PTPeterson Jo · El Dorado, KSN550RESimply Living LLC · Fort Myers, FLN550TXClassic Wings And Wheels LLC · Orlando, FLN550UClear Sky Aviation LLC · Mccall, IDN550WPJacobs Justin · San Francisco, CAN550ZKAviation Trust Company LLC Trustee · Oklahoma City, OKN5511CDss Consulting LLC · Omaha, NEN5513BDemartini Mark D · San Jose, CAN5515NAronoff Raymond · Katy, TXN5516CCarson Kirk · Dalhart, TXN5517SRussell Charles B · Union City, TNN5517UKoegel John C · Flint, MIN55180Craig Warren J · Ellerbe, NCN5519BRaven Air LLC · Athol, IDN551BGOne Bravo Gulf LLC · Lutz, FLN551DSFreeburg Farms Inc · Worley, IDN551JBValiair Lc Trustee · Casper, WYN551SFFilmlites Montana LLC · Bozeman, MTN551TSAbc Air Inc · Eveleth, MNN5521BHunt Nicholas R · Bozeman, MTN5522BBazerko Family Fun LLC · Caldwell, IDN5522COswald Ron · Eden Prairie, MNN5523SDj Flight Service LLC · Little Falls, MNN5523YSimmons Scott · Anchorage, AKN5525USheriffs Department · Oakland, CAN5526BDoelger Parker · Norwood, NYN5527BAdrenaline Inc · Chambersburg, PAN5528AWarden Hutterian Brethren · Warden, WAN5529NTime 2 Fly LLC · Conroe, TXN5529SBreaking Wind Aviation LLC · Brainerd, MNN552MNMtc Air LLC · Blue Ridge, GAN552RWWelch Richard L · Tazewell, TNN5530BInternational Air Services Inc Trustee · Carson City, NVN5531ASouther Field Aviation Inc · Americus, GAN5531BNighthawk N8231g LLC · Granite Bay, CAN5533EEnergy Transfer Aviation LLC · Spring, TXN5534NClifford English · Mesa, AZN5535BAvery John W · Fergus Falls, MNFirst renewal noticeN5535NBerry William Trustee · Harrison, ARN5536BHigh Five Flying LLC · Amarillo, TXN5536NBrown Peter L · Riverton, CT
Back to AD 84-10-01 R1