AD 2002-17-53
Registered aircraft · 6,266
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-17-53')
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-17-53')
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-17-53') 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-17-53') 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.
N111GAGeorges Aviation Services Inc · Honolulu, HIN111LFZimmerman Leland · Center, CON111MWSaratoga 181 LLC · Mesa, AZN111PKScruggs 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, CAN1125GBlue Knot LLC · Teguesta, FLN112AANestor Richard · Portsmouth, NHN112HDJackson Larry D · Orlando, FLN112RMAppalachian Aviation LLC · Harrisonburg, VAN1139LMathewson Crews Aviation LLC · Indianapolis, INN113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN113ECCarrasco Enrique · Jupiter, FLN113HMAkins Tal M · Register, GAN113MVRettig Air LLC · Riverside, CAN113TLKramer David P · Lebanon, TNN113TRBell Thomas E · Henniker, NHN1140XReaper LLC · Britton, MIN11414Van Bortel Aircraft Inc · Arlington, TXN1143XTj Allen Bulk Services LLC · Newport, NYN1145BKampton William Charles · Napa, CAN114ADBailey Walter A III · Cincinnati, OHN114BLLoose David C · Blanco, TXN114GTEnders Richard A · San Bernardino, CAN114JTVanbeek Donald Eugene · Tualatin, ORN114KR H Welsh LLC · Crescent City, FLN114MDUrsic Albert J · Minden, NVN114MTSattig Henry B II · Cortez, CON114PBBernabucci Christian J · Mapleton, NDN114PRC W 3 LLC · San Juan, PRN114RCAsbury William A · Bridger, MTN114RRMdb Air LLC · Poway, CAN114RWLaw C Scott · Oklahoma City, OKN114SACustom Air International LLC · Homestead, FLN114TBWelch D Michael · Foster City, CAN114TLLa Soplaera Realty LLC · Niwot, CON1151ZRenfro Michael W · Bethel, AKN1154XKelley Jay D · Lake Havasu City, AZN1157SDig2fly LLC · Sandpoint, IDN115DWMav LLC · Erie, CON115GTWahl John H · Rockwell City, IAN115JDC R Aviation Inc · Miami, FLN115KTMulva Jonathan · De Pere, WIN115MDSpecial Orthogonal Group LLC · Dover, DEN115SZThree Greens LLC · San Jose, CAN1165XLechtenberg Lance · El Dorado, KS
Back to AD 2002-17-53