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.
N52994Carpenter Michael · Hardin, MON52996Mcnab Michael J Trustee · Slayton, MNN52997Plaugher Carl L · Cocoa Beach, FLN52998Frauenhoff Frank W · Manhattan, NVN5299ERosenberg Douglas S · Tillamook, ORN529JKSkydogs LLC · Fairfax, VAN529PHSilveraire LLC · Forest Lake, MNN529TTCarter Casey C · Sanger, TXN52AJMccarty Aaron T · Wasilla, AKN52CRCairns Douglas S · Bozeman, MTN52ENRefuge Properties LLC · Goshen, KYN52GVCompass Aviation Maintenance LLC · Shelby, NCN52HAAssociated Packaging Inc · Gallatin, TNN52MMHappy Sky LLC · Brooklyn, NYN52TMJorgensen Aviation Inc · Richfield, UTN5300ARunzel Brothers Aviation LLC · Bensenville, ILN5302NNorthwoods Air LLC · Orono, MEN5302VSniader David J · Miami, FLFirst renewal noticeN5302XFnb Flying Club LLC · Gallatin, TNN5303BConnolly Joshua K · Vero Beach, FLN5303XRedemption Inc · Kodiak, AKN5304BJ & B Aviation · New Martinsville, WVN5304DDelta Enterprises LLC · Kasilof, AKN5304NHotrod Aviation LLC · Fayetteville, ARN5305BHamlin Curtis G · North Pole, AKN5305NBennett Brian · Horseheads, NYN53076Rjr Aviation LLC · Ridge, NYN5307BHunter Warren M · Rainelle, WVN5309BKadlubowski Michael J · Colorado Springs, CON5309DPotter John · Payson, UTN530MBBrill Nathan · Austin, TXN530TACaprock Dairy LLC · Muleshoe, TXN530TC530tc LLC · Nashville, TNN5310ENeiman Enviroments Inc · Junction, TXN5311SGagliardi Richard M Trustee · Mill Spring, NCN5313NGavin Patrick H · Carlsbad, CAN5313USky Quest 210 LLC · Clarksdale, MSN5314VBurke Sterling M · Olympia Fields, ILN5314XMoody Bible Institute Of Chicago · Spokane, WAN5315BBrady Brian O · Kirkland, WAN5315XAtarah LLC · Tucson, AZN5316DErickson Todd E · Wasilla, AKN5317ABlue Skies Air LLC · Allen, TXN5317BWilson Bach M · Piedmont, SCN5317NJones Timothy S · St Simons Is, GAN5318ABuchanan Harvey · Townsend, MAN5318DBolton Frederick J · Willow, AKN5318VTyson Ron A · Fredericksburg, TXN5319BMcpherson Russell H · Forest Lake, MNN5319NUSA Aviation LLC · Fairfield, ME
Back to AD 84-10-01 R1