OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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:94-18-04-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:94-18-04-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.

N99200Airmotive Service LLC · Brigham City, UTBuilt 1946 · S/N 1823N99201Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1824N99207Silvagnoli Miguel · Bay Shore, NYBuilt 1946 · S/N 1830N99215Stasny James M · Jacksonville, FLBuilt 1946 · S/N 1838N99216Prentice Robert D · Ripon, WIBuilt 1946 · S/N 1839N99226Mcclellan Fred · Grand Blanc, MIBuilt 1946 · S/N 1849N99228Ching Radford G · Elsie, MIBuilt 1946 · S/N 1851N99229Yanks Air Museum · Baldwin Park, CABuilt 1946 · S/N 1852N99231Stone Charles N · Chetopa, KSBuilt 1946 · S/N 1854N99233Advanced Airplanes Associates Inc · Keller, TXBuilt 1946 · S/N 1856N99235Wido Mark C · Plainfield, ILBuilt 1946 · S/N 1858N99238Urash Richard M · Americus, GABuilt 1946 · S/N 1861N99244Strutzenberg Kent R · Manson, IAS/N 1867N99246Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 1869N99251Jefson Scott A · Shelbyville, ILBuilt 1946 · S/N 1874N99264Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1887N99267Oswald Merlin W · Herington, KSS/N 1890N99274Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1946 · S/N 1897N99280Eastern Stearman Inc Trustee · Leesburg, VAS/N 1903N99281Mackie Kevin S · Longview, WAS/N 1904N99287Sweet Pea Flying Club LLC · State Center, IABuilt 1946 · S/N 1910N99297Baird Mark A · Alameda, CABuilt 1946 · S/N 1920N99307Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1930N99309Sheridan Joshua M · Janesville, WIBuilt 1946 · S/N 1932N99310Miller Larry W · Lexington, KYBuilt 1946 · S/N 1933N99315Shackleford Larry D · Southmont, NCS/N 1938N99317Madre Charles P · Hertford, NCBuilt 1946 · S/N 1940N99322Bost Kenneth A · Rockwell, NCBuilt 1946 · S/N 1945N99325Registration Pending · Morrisville, PARegistration pendingBuilt 1946 · S/N 1948N99326Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1949N99327Bierck Gregory R · Lafayette, INBuilt 1946 · S/N 1950N99334Ferster William J · Berlin, MDFirst renewal noticeBuilt 1946 · S/N 1957N99335Mohler Bruce A · Peru, INBuilt 1946 · S/N 1958N99337Yocom Jason D · Cocoa, FLS/N 1960N99340Middelkamp Rick D · Platte City, MOBuilt 1946 · S/N 1963N99353Aeroplanes Over Idaho · Caldwell, IDS/N 1976N99367Brown Paul M · Batson, TXBuilt 1946 · S/N 1990N99369Burdett Jr Robert P · Lilburn, GABuilt 1946 · S/N 1992N99372Bevard David · Skiatook, OKBuilt 1946 · S/N 1995N99387Hobschaidt Kurt · Pittstown, NJBuilt 1946 · S/N 2010N99388Holcomb Gary G · Palestine, TXBuilt 1946 · S/N 2011N99391Wood Robert · Trezevant, TNBuilt 1946 · S/N 2014N99398Brimmer Johnyjoe · Gillette, WYBuilt 1946 · S/N 2021N99399Adams Thomas D · Marathon, NYBuilt 1946 · S/N 2022N99402Sidusky Judy A · Queensbury, NYBuilt 1946 · S/N 2025N99405Rathe Don A · Fort Mohave, AZS/N 2028N99406Bahm Martin P · Edmond, OKBuilt 1946 · S/N 2029N99407Brown Doyle E · Jonesboro, ARFirst renewal noticeS/N 2030N99411Wido Mark · Plainfield, ILBuilt 1946 · S/N 2034N99421Wilhelm Kenneth H · Helena, MTBuilt 1946 · S/N 2044
Back to AD 94-18-04 R1