OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242N25466Bas Part Sales LLC · Greeley, COBuilt 1986 · S/N E-2303N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255N2548WGotschall Harry A · San Antonio, TXBuilt 1974 · S/N MC-257N2549625496 LLC · Muscatine, IABuilt 1986 · S/N E-2305N254AAKelly Charles M · San Angelo, TXBuilt 1959 · S/N D-6032N254DAlwin Brandon · Laredo, TXBuilt 1962 · S/N TC-339N254DPPulsipher David · Saint George, UTBuilt 1990 · S/N E-2527N255BEkstrum Eric S · Mound House, NVS/N D-1570N255BABgp Realty Inc · Boca Raton, FLBuilt 1967 · S/N TE-364N255BDInmotion Media Group LLC · Henderson, NVBuilt 1954 · S/N D-3817N255EM255em LLC · Tampa, FLBuilt 1973 · S/N TC-1552N255FSSharpline Converting Inc · Wichita, KSBuilt 1980 · S/N TC-2306N255KBailey Michael S · Sarasota, FLBuilt 1961 · S/N TC-74N255MAKmco Inc · Lenexa, KSBuilt 1967 · S/N TE-318N255RWas Group LLC · Wilmington, DEBuilt 1973 · S/N TC-1518N255WPUnited States Air Force Owner · Hanscom Afb, MAFirst renewal noticeS/N TF-38N255XMS-Tee Corp · Mineri Wells, TXBuilt 1966 · S/N TE-263N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393N25631Myers Robert G · Monument, COBuilt 1973 · S/N TC-1523N25632Struck Larry G · Gardnerville, NVS/N D-9435N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438N25642Pester Jerome B · Hingham, MTBuilt 1973 · S/N CE-457N25659Greenery LLC · Wilmington, DEBuilt 1973 · S/N TC-1596N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522N25665Franks Bryan · Camarillo, CABuilt 1973 · S/N CE-459N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472N25676Ciabattoni David E · Wallingford, PABuilt 1973 · S/N TC-1597N25681Heli-Ventures Inc · Wilmington, DEBuilt 1973 · S/N CE-460N25691Marty Daniel A · Birmingham, ALBuilt 1973 · S/N CE-462N25698Tupelo Aeronautics Inc · Tupelo, MSS/N TC-1603N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081N256GRRicciotti Gerard · Annapolis, MDBuilt 1956 · S/N G-754N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107N256NNichols Richard C · Port Orange, FLS/N BG-398N256TCHyder Racing LLC · Kalispell, MTBuilt 1967 · S/N TG-39N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479N25745Bird Dog Aviation LLC · Kalispell, MTS/N TE-949N25798Hayek Investments LLC · Gulf Breeze, FLBuilt 1986 · S/N E-2308N257MWillis Charles A · Arlington, TXBuilt 1958 · S/N D-5604N257RD4 Flying Z'S LLC · Murfreesboro, TNS/N M-2137N258ESanogo Fousseni · Houston, TXBuilt 1964 · S/N TC-701N258JYDodson International Parts Inc · Rantoul, KSS/N E-2343N258PChamberlin Charles · Winchester, TNBuilt 1981 · S/N TC-2414
Back to AD 99-05-13 R1 WD