AD 84-10-01 R1
Registered aircraft · 20,483
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.
N22373Roche Timothy P · Falls Church, VAN2237GSmith Caleb · Beggs, OKN2238CGorham Wendy J · Grand Rapids, MNN22396Jordan Lennon D · Bartow, FLN2239GPotter Cleve J · Fresno, CAN223BTMull David L · Kathleen, GAN223EMKqm Aviation · Manassas, VAFirst renewal noticeN223HCG206 LLC · San Juan, PRN223LDGaston'S White River Resort Inc · Lakeview, ARN223MEChem-Air LLC · Shreveport, LAN223RJCline Larry J · Beeville, TXN223SCSurdex Corp · Chesterfield, MON223TLZanghi Michael · Katy, TXN223WHPerrin James F · Bancroft, WIN2241RHappy Landings Aero LLC · Wilmington, DEN2241SEdmondson James K · Lemoore, CAN2242CCac Of Ar LLC · White Hall, ARN2242GNelson Mark · Fairbanks, AKN2243CBelleville Livestock Market Inc · Belleville, PAN2244CSkywagon Aero LLC · Wilmington, DEN2244TAmerican Elevator · Ruidoso, NMN22459Hatch Leasing Company LLC · Flagstaff, AZN2245CChesnut Lonnie R · Palmer, AKN2245GSkyair Express LLC · Overton, NVN2246RMontgomery Brian · Houston, TXN2247SCarnes Andrew P · Wichita Falls, TXN2247TYellow Jacket Flying Club Inc · Atlanta, GAN2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeN2249CHepburn Joseph · Towanda, KSN2249GDelph Timothy M · Wasilla, AKN2249SDlw Flight Services LLC · Waterloo, ILN224ACSellers Scott R Trustee · Racine, WIN224ALAirborne Support Group LLC · Marion, MTN224EMFsm Aviation LLC · Edmond, OKN224HThompson Dennis P · Spokane Valley, WAN224KAChambers William Melvin Jr · Azle, TXN224PKValiair Lc Trustee · Casper, WYN224PTLee Mark W · Blaine, MNN2251GValentine Terence S · Glennallen, AKN2251TGardner Bryan T · Rancho Cucamonga, CAN2252CMickey Donald J · Albuquerque, NMN2252GRutter Eric R · Anchorage, AKN2252RStout Walt · White Hills, AZN2252SSpider Lips Aviation LLC · Fischer, TXN2253CFoss David K · Anchorage, AKN2254CCook Charles Nicholas · Lakeside, TXN2254GSorrels Robert S · Starkville, MSN2256CCnd Aerospace Ltd · Telluride, CON2257RCanales Jorge · Anthony, NMN2258JPluhar Darrin P · Ekalaka, MT
Back to AD 84-10-01 R1