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.

N93697Seiler Kathryn R · Quitman, ARBuilt 1946 · S/N 1020N93705Erickson Jeanne H · Warroad, MNBuilt 1946 · S/N 1028N93712Hetrick David R · Alexandria, PABuilt 1946 · S/N 1035N93716Central Washington Sport Pilots Inc · Yakima, WABuilt 1946 · S/N 1039N93717Wolter Michael S · Dallas, TXBuilt 1946 · S/N 1040N93724Russell Walter B · Boone, COBuilt 1946 · S/N 1047N93727Hjelle Mark L · Barrett, MNBuilt 1946 · S/N 1050N93744Hanneman Rhea Ann · Abilene, TXBuilt 1946 · S/N 1067N93746Raty Ronald J · Bremerton, WABuilt 1946 · S/N 1069N93749Denchel Thomas W · Prosser, WABuilt 1946 · S/N 1072N93751Gable Clark F · Oxford, ALBuilt 1946 · S/N 1074N93760Dillman David O · Harrogate, TNS/N 1083N93771Peppas George D Jr · Fort Wayne, INBuilt 1946 · S/N 1094N93775Stack Richard P · Lacey, WABuilt 1946 · S/N 1098N93788Gregory Vernon L · Swansea, SCS/N 1111N93798Schrimpf Robert J · Batesville, INBuilt 1946 · S/N 1121N93803Cuthbert Alan R · Edwardsburg, MIBuilt 1946 · S/N 1126N93805Bass Daniel · Winona, MNBuilt 1946 · S/N 1128N93807Knorr D Steven · Shiocton, WIBuilt 1946 · S/N 1130N93808Dante K Escobar · Davenport, FLBuilt 1946 · S/N 1131N93820Tenforty Inc · Vermillion, SDBuilt 1946 · S/N 1143N93823Courson Keith A · Boise, IDS/N 1146N93826Azeredo Ian G · Ringwood, NJBuilt 1946 · S/N 1149N93828Stanford Dolph B · Watauga, TXS/N 1151N93833Bergstrom Gunnar · Kenai, AKBuilt 1946 · S/N 1156N93834Logerfo Richard · Amsterdam, NYBuilt 1946 · S/N 1157N93838Burke Dan · Kirkland, WABuilt 1946 · S/N 1161N93841Baker Peters · Clarinda, IABuilt 1946 · S/N 1164N93850Rollison Michael W · Fairfield, PABuilt 1946 · S/N 1173N93851Bayne William R · Kaufman, TXBuilt 1946 · S/N 1174N93852Swartwout William A · Selbyville, DEBuilt 1946 · S/N 1175N93853Averett Joseph B · Denham Springs, LAS/N 1176N93862Graumfear LLC · Cincinnati, OHBuilt 1946 · S/N 1185N93868Simpson Daniel J · Polk City, FLBuilt 1946 · S/N 1191N93869Jacobsen Ian M · Lincoln City, ORBuilt 1946 · S/N 1192N93871Flowers Cleon · Conway, ARBuilt 1946 · S/N 1194N93880Ercoupe Aviation LLC · Saint Peters, MOFirst renewal noticeBuilt 1946 · S/N 1203N93883Schmidt John P · Lafayette, INBuilt 1946 · S/N 1206N93886Dalsco Inc · Dover, DES/N 1209N93888Andrews Kenneth G · Kuna, IDFirst renewal noticeBuilt 1946 · S/N 1211N93889Mcgrath John P · Concord, NHBuilt 1946 · S/N 1212N93892Lee Justin W · Maud, TXS/N 1215N93896Lambert Joe B · Brainerd, MNS/N 1219N93902Carlson Bruce D · Umatilla, ORBuilt 1946 · S/N 1225N93905Siska James Joseph · Plain City, OHBuilt 1946 · S/N 1228N93906Shiloh Aviation LLC · Ramer, TNBuilt 1946 · S/N 1229N93915Lee Justin W · Maud, TXBuilt 1946 · S/N 1238N93921Amann David P · Wesley Chapel, FLBuilt 1955 · S/N 1244N93926Brown David M · Aledo, TXBuilt 1946 · S/N 1249N93930Dubbert Roger D · Mexico, MOBuilt 1946 · S/N 1253
Back to AD 94-18-04 R1