AD 2002-23-06
Registered aircraft · 16,325
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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.
N113AFRa Aviation LLC · Clinton, LAN113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN113CDDowning Charles E · West Melbourne, FLFirst renewal noticeN113CJMarshall Joshua · Chuckey, TNN113ECCarrasco Enrique · Jupiter, FLN113HMAkins Tal M · Register, GAN113HPState Of Ohio · Columbus, OHN113JBMcdonald Aviation Inc · Knoxville, TNN113JCMcdonnell Bryant E · Boulder, CON113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN113KCGolden Valley LLC · Missoula, MTN113MVRettig Air LLC · Riverside, CAN113TLKramer David P · Lebanon, TNN113TRBell Thomas E · Henniker, NHN11402Mcdowell Charles R II · South Charleston, WVN1140XReaper LLC · Britton, MIN11414Van Bortel Aircraft Inc · Arlington, TXN1142UCorporacion Dbm LLC · Miami, FLN1143XTj Allen Bulk Services LLC · Newport, NYN1145BKampton William Charles · Napa, CAN114ADBailey Walter A III · Cincinnati, OHN114ANHake Scott W · Swoope, VAN114ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYN114AWCameron Hugh R · Gainesboro, TNN114BShankle Michael L · Culpeper, VAN114BLLoose David C · Blanco, TXN114BMJaswal Faisal · La Conner, WAN114BXRcs Aviation LLC · Indian Trail, NCN114CECommander Air LLC · Purcellville, VAN114CGUnited Aviation LLC · Whitehall, PAN114CTTairex Inc · Wilmington, DEN114DFNorthwoods Distribution Services Inc · Rhinelander, WIN114DWLayman Nathan L · Hudson, WIN114EEEngstrom Eric R · Eastover, NCN114ELNaperville Flying Club · Woodridge, ILN114ERIhle Edward A · Elmendorf, TXN114GTEnders Richard A · San Bernardino, CAN114HPDolanair LLC · Coal Valley, ILN114JAWright Richard D · Acworth, GAN114JGMack Phillip B · Tampa, FLN114JTVanbeek Donald Eugene · Tualatin, ORN114KR H Welsh LLC · Crescent City, FLN114KJRegistered aircraftFirst renewal noticeN114KLKaruppannan Venkatachalam · Troy, MIN114LRegan Properties LLC · Coeur D Alene, IDN114MBCrew Andrew P · Chester, CTN114MDUrsic Albert J · Minden, NVN114MGW F Carter Construction Inc · Arlington, TXN114MKGood Thomas Ryan · Grapevine, TXN114MTSattig Henry B II · Cortez, CO
Back to AD 2002-23-06