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.

N1912LRegistered aircraftBuilt 1976 · S/N E-866N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656N1914DAdams Lawrence H · Prescott, AZBuilt 1952 · S/N D-3143N1914LDeakins Glenn F · Ringgold, GAS/N MB-803N1915DAtterberry Charlie G · Rockwall, TXBuilt 1952 · S/N D-3152N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794N1919DWarren Wesley L · Coeur D Alene, IDBuilt 1952 · S/N D-3191N191AAPelz Thomas G · Boscobel, WIBuilt 1959 · S/N D-5914N191BCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1956 · S/N D-4517N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716N191GA5056 Bonanza LLC · Tulsa, OKBuilt 1957 · S/N D-5056N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042N191JKN191jk LLC · Brunswick, GABuilt 1982 · S/N E-1943N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172N1920DHunt James W · Maryville, TNBuilt 1952 · S/N D-3192N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579N1921DBrickhouse Aviation LLC · Franklin, TNS/N D-3193N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819N1926DKoosmann Mark R · Corcoran, MNBuilt 1956 · S/N D-3198N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587N1927DHawksworth Jeff · Laveen, AZS/N D-3199N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964N192BSlater Patrick · Glasgow, KYS/N D-4790N192HEastern Stearman Inc Trustee · Leesburg, VABuilt 1945 · S/N 6723N192QFisher Robert · Shoreacres, TXS/N TC-783N1930DFletcher Ellexis L · Corpus Christi, TXBuilt 1952 · S/N D-3203N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1933WHanson Garrick D · Clayton, NCS/N MB-597N1935DCoppage Walter J · Wichita Falls, TXBuilt 1952 · S/N D-3209N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797N1936LAnderson Brian E · Edmond, OKBuilt 1976 · S/N M-1846N1936WDelgatto Robert G · Bellingham, WAS/N MB-599N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419N1937WMcculloch Jordan · Enfield, CTBuilt 1973 · S/N MB-600N1938DPlane Crazy Aviation LLC · Hickory, NCBuilt 1952 · S/N D-3214N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414
Back to AD 99-05-13 R1 WD