AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN856FGRidgeline Assets LLC · Wilmington, DEN8570BPilot Coaches LLC · Little Falls, MNN8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILN8570JBitikofer Brent · Kansas City, KSN8570QTwo O Six Inc · Fort Myers, FLN8570THeuett Clint James · Asotin, WAN8571JRoam Gary A · Venice, FLN8571SStevenson Intermountain Seed Inc · Ephraim, UTN8571UBell Charles M DBA · Warsaw, NYN8571XRegistered aircraftN8572RReese Owein · Glen Rock, NJN8572SPaulan Beverly S · Antioch, ILN8572TAerial Wayfarer LLC · San Antonio, TXN8572USkyline Aviation Solutions LLC · Grosse Ile, MIN8573GFichtner Eric Lowell Russell · Concord, NCN8573S182 Flight Corp · Bronx, NYN8574JHubenthal William L · Carbondale, ILN8574XDiscover Aviation Center LLC · Elyria, OHN8575GAero Services Lc · Woods Cross, UTN8575SDallas William J · Eastsound, WAN8575TChristensen Del S Trustee · Friendswood, TXN8575UVermillion County Flying Club · Danville, ILN8576BRomeo Delta Inc · Elsie, MIN8576GSchaefer John · Liberty Hill, TXN8576QThompson Robert Lee · Moore, OKN8577GLakey Robert E · Arlington, TXN8577SRegistration Pending · Concord, GARegistration pendingN8578JParagon Aviation LLC · Reading, PAN8579SHopp Gregory R · Columbus, OHN8579TGoldschmidt Scott · Cottonwood, CAN8579UStueckradt Steve · Ankeny, IAN857AUAuburn University · Auburn, ALN857NTSmeltz Kent · Dornsife, PAN857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeN857SPSoutheastern Oklahoma State University · Durant, OKN8580BB&R Aircraft LLC · Wadsworth, OHN8580GRhoat William E · Paso Robles, CAFirst renewal noticeN8580QBald Eagle Aviation LLC · Oakley, UTN8580TBas Part Sales LLC · Greeley, CON8580UBaker Shane A · Marshall, WIN8581FAccurate Aero LLC · Minden, NVN8581SBlack Samuel W · Kennesaw, GAN8581ULarkin John · Cambridge, IDN8581XRegistered aircraftN8582BHousley William M · Jasper, ALN8582JMarchione Laverne R · Diamondville, WYN8582UMartin Livestock LLC · Ione, CAN8583SDevillier Roland James · Winnie, TXN8583UVon Burg Jon B · Hull, IL
Back to AD 79-10-14 R1