AD 2002-19-03
Registered aircraft · 12,723
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-19-03')
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-19-03')
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-19-03') 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-19-03') 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.
N111PKScruggs Ken · Galloway, OHN111SEKeith Fischer · Gig Harbor, WAN111SNHalbert Kevin · Tyler, TXN111SXJcccs Land And Cattle LLC · Harrisburg, NEN111UCRcht LLC · Mason, OHN111WYN111wy LLC · Wilmington, DEN1122EVasey Igor · San Francisco, CAN1123FUrsus Air Services · Anchorage, AKN1129PBonzo Air LLC · Saint Petersburg, FLN112ADfss LLC · Henderson, NVN112AANestor Richard · Portsmouth, NHN112HDJackson Larry D · Orlando, FLN112JJNovember Alpha LLC · Dover, DEN112KGMedore Douglas A · Romoland, CAN112LRRazzi Leonard F Jr · Glenmoore, PAN112RMAppalachian Aviation LLC · Harrisonburg, VAN112SMReisdorfer Mark J · La Follette, TNN112SPMinnesota Department Of Public Safety · Saint Paul, MNN112WFWhiskey Fox LLC · Kirkland, WAN112WMInternational Air Services Inc Trustee · Carson City, NVN1132QWattum Investments LLC · Kodiak, AKN1134DFma Auto Sales LLC · Greensboro, NCN11379Bas Part Sales LLC · Greeley, CON1137Y412 Jackson Site Development LLC · Oxford, MSN1139LMathewson Crews Aviation LLC · Indianapolis, INN113ACInternational Air Services Inc Trustee · Carson City, NVN113AFRa Aviation LLC · Clinton, LAN113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN113CDDowning Charles E · West Melbourne, FLFirst renewal noticeN113ECCarrasco Enrique · Jupiter, FLN113HMAkins Tal M · Register, GAN113HPState Of Ohio · Columbus, OHN113JCMcdonnell 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, NHN1140XReaper LLC · Britton, MIN11414Van Bortel Aircraft Inc · Arlington, TXN1142UCorporacion Dbm LLC · Miami, FLN114ADBailey 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, VA
Back to AD 2002-19-03