Skip to content

Registered aircraft · 6,915

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

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:71-13-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:71-13-01-R1') ORDER BY n_number

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:71-13-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:71-13-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:71-13-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:71-13-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.

N2270GNorris Edgar L Jr · Charlotte, NCBuilt 2007 · S/N T18208726 N2270QSure Aviation LLC · North East, MDBuilt 2007 · S/N T18208728 N2272DLucky Marmot Aviation LLC · Traverse City, MIBuilt 2007 · S/N T20608743 N2272PSchmitz William M · Napa, CABuilt 2007 · S/N T20608745 N22761Kop Aviation LLC · El Paso, TXBuilt 2007 · S/N T18208734 N2278YWplanec LLC · Gig Harbor, WABuilt 2007 · S/N T18208736 N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198 N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184 N227EMVisceral Technologies LLC · Yulee, FLBuilt 2001 · S/N 3257208 N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N227WDPowell David C · Ingram, TXBuilt 1990 · S/N 4622097 N227WFTrayler James · Waco, TXBuilt 2004 · S/N T18208288 N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242 N228AZCiaglia Caesar Earle · Mokena, ILBuilt 2009 · S/N T18208969 N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686 N228CMKittleson Allen F · Granbury, TXBuilt 1973 · S/N 73-31058 N228GHopkins Boone K · Saint Simons Is, GAS/N 612 N228HSSweeney David H · Houston, TXBuilt 2003 · S/N T20608419 N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711 N2291SRegistered aircraftBuilt 2007 · S/N T18208738 N2292WA & L Enterprises LLC · Maiden Rock, WIBuilt 2023 · S/N T20609725 N22952Winging It LLC · Lindon, UTBuilt 2007 · S/N T18208740 N2296QKhawly Pablo Nickolai · Miramar, FLBuilt 1977 · S/N 32R-7780244 N2297MHunter Stokes & Associates LLC · Douglasville, GABuilt 1977 · S/N 32R-7880061 N2297QFact Ware Inc · Newtown, PABuilt 1977 · S/N 32R-7780245 N2297VTicknor Robert James · Adel, IABuilt 2007 · S/N T18208742 N2298MLeft Seat Flyers LLC · Mount Pleasant, SCBuilt 1977 · S/N 32R-7880062 N229ALCowboy Pilots LLC · Gilbert, AZBuilt 1988 · S/N 078 N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252 N229MAN&D Executive Services LLC · San Antonio, TXS/N 4636129 N229MMFair Winds Aviation LLC · Cheyenne, WYBuilt 2008 · S/N 4692029 N22CHSupergo LLC · Menlo Park, CABuilt 1999 · S/N T20608101 N22CKAdams Ventures LLC · Lowell, ARBuilt 1982 · S/N 32R-8213048 N22CSClear Skies Aviation Enterprise LLC · Dover, DEBuilt 2017 · S/N T20609504 N22CUGbh Aviation · Santa Monica, CABuilt 2007 · S/N T18208773 N22DTMartin Communications Inc · West Monroe, LABuilt 1975 · S/N 32-7640033 N22HMPetrzelka Ivan · Red Bluff, CABuilt 1990 · S/N 27-0037 N22HYTlc2 LLC · Missoula, MTBuilt 2024 · S/N T18209150 N22MVJm Aviation Holdings LLC · Loudonville, NYBuilt 2024 · S/N 4636843 N22NLD2k Aviation LLC · Boyden, IABuilt 1987 · S/N 32R8629006 N22SYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 4636122 N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541 N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074 N2301QFarm West LLC · Missoula, MTBuilt 2001 · S/N T20608263 N2304DBb4 Leasing LLC · Lees Summit, MOBuilt 2010 · S/N 4692154 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N230BKErickson Bernard Rudolph · Saint Cloud, MNBuilt 2023 · S/N T20609747 N23138Donaldson Docks Inc · Estherville, IAS/N 32R-8529010 N2313QRegistered aircraftBuilt 2010 · S/N 4636474

Back to AD 71-13-01 R1