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.

N7568CSmundin George · Munster, INBuilt 1959 · S/N 5685N7569CBellamy John Mark · Savannah, NYBuilt 1959 · S/N 5686N7570CShackelford Jeffrey A · Morris, ILBuilt 1959 · S/N 5687N7571CEastland Walter J · Frankston, TXBuilt 1959 · S/N 5688N7573CReynolds Terry · Phoenix, AZBuilt 1959 · S/N 5690N75RD75rd LLC · Moraine, OHS/N A-93N767WRHangar R LLC · Irvington, ALBuilt 1966 · S/N A-133N772CMDuncan John S · Maple, NCS/N 4662N7771JSchumann Jay W · Hampton, IAS/N A-27N77ZGorman John C · St Augustine, FLS/N 497N789JJFallon Jeffrey C · Berlin, MABuilt 1946 · S/N 1541N799TXCowden Timothy L · Escondido, CABuilt 1946 · S/N 670N800PYBigge George F Jr · Pittsgrove, NJBuilt 1966 · S/N A-162N8144NMckee James L · Caledonia, OHBuilt 1947 · S/N 4597N818SWAbbott Don W · Sanibel, FLBuilt 1968 · S/N B-279N825DCMcdaniel Ronnie J Sr · Starkville, MSBuilt 1966 · S/N A-124N82REEpton Richard C · Williamson, GABuilt 1946 · S/N 2179N846MDSimons Barbara A · Enderlin, NDBuilt 1946 · S/N 3254N86962Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 135N86965Mcguckian Michael P · Colorado Springs, COS/N 138N86972Parnell Jeffrey R · Garrison, MOBuilt 1945 · S/N 145N86978Yoder Aaron W · Belvidere, TNBuilt 1945 · S/N 151N86982Forseth David E · Arena, WIBuilt 1945 · S/N 155N86984Walts Robert · Moraga, CABuilt 1945 · S/N 157N86994Poliak Mark A Trustee · Carmel, INS/N 167N86996Gregory Vernon L · Swansea, SCBuilt 1945 · S/N 169N87003Laws Richard B · Apache Junction, AZBuilt 1945 · S/N 176N87014Cohen David M · Gaithersburg, MDS/N 187N87016Henschel Warren · Kingwood, TXBuilt 1945 · S/N 189N87022Silva Brent F · Lake Hughes, CABuilt 1945 · S/N 195N87024Perry Larry G · Andover, KSFirst renewal noticeS/N 197N87030Long Robert D · Kinston, NCBuilt 1945 · S/N 203N87034Prescott Paul H · North Augusta, SCBuilt 1945 · S/N 207N87037Drake Paul A · Eagar, AZBuilt 1945 · S/N 210N87040Burr Walter E · Tecumseh, MIBuilt 1945 · S/N 213N87042Gregory Vernon L · Swansea, SCBuilt 1945 · S/N 215N87046Young Eagles Flying Club LLC · Lady Lake, FLS/N 219N87048Sale Reported · Brooklyn Center, MNSale reportedBuilt 1946 · S/N 221N87051Strong Neil E · Pittsburg, TXBuilt 1946 · S/N 224N87055Beste Robert K · Sauk Centre, MNBuilt 1946 · S/N 228N87071Cortes-Batista Eliacim · Arlington, TXBuilt 1946 · S/N 244N87072Galloway George G · Fort Worth, TXBuilt 1946 · S/N 245N87074Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 247N87077Dombrowski Christopher · Livermore, CABuilt 1946 · S/N 250N87080Schoenfelder James N · Huron, SDS/N 253N87085Pyle Dana C · Naples, FLBuilt 1946 · S/N 258N87086Bernard Kate L · Neenah, WIBuilt 1946 · S/N 259N87091Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 264N87093Wheeler Russell E · Roxbury, CTS/N 266N87096Wright Ronald E · Overland, MOBuilt 1946 · S/N 269
Back to AD 94-18-04 R1