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.

N93932Specht Leo M · Towner, COBuilt 1946 · S/N 1255N93936Smith Charles A · Perry, KSBuilt 1946 · S/N 1259N93949Jardine Brian E · Greenleaf, IDBuilt 1946 · S/N 1272N93950Fust Irwin H · Anderson, CABuilt 1946 · S/N 1273N93953Veltri Laura D · Kismet, KSBuilt 1946 · S/N 1276N93955Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1278N93960Smith Roy V · Trimble, TNBuilt 1946 · S/N 1283N93963Bug Smashers LLC · Winfield, KSBuilt 1946 · S/N 1286N93966Busch Ronae M · Menoninee, MIBuilt 1946 · S/N 1289N93968Flying Wrenches · Buhl, IDS/N 1291N93977Hardin Melissa K · Terrell, TXBuilt 1946 · S/N 1300N93978Coleman Stanley · Lefors, TXS/N 1301N93984Arsenault William R · Rehoboth, MABuilt 1946 · S/N 1307N93994Pound John · Tucson, AZBuilt 1946 · S/N 1317N93997Registration Pending · Maud, TXRegistration pendingBuilt 1946 · S/N 1320N94003Boggs Marty N · Thomasville, NCBuilt 1946 · S/N 1326N94004Fremont Aviation · Fremont, NEBuilt 1946 · S/N 1327N94007Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1330N94008Buck Jon R · Sykesville, MDBuilt 1946 · S/N 1331N94012Mcglashan Richard L · Round Rock, TXS/N 1335N94020Lee Justin W · Maud, TXBuilt 1946 · S/N 1343N94026Dinucci Gino · Clearwater, FLBuilt 1946 · S/N 1349N94030Williamson Motor Co Inc · Wewoka, OKBuilt 1946 · S/N 1353N94036Tlc Olson Construction LLC · Huron, SDBuilt 1946 · S/N 1359N94039Antonelli Michael · Mesa, AZS/N 1361N94040Magnolia Aviation Solutions LLC · Sheridan, WYBuilt 1946 · S/N 1363N94041Robinson Randall L · Crawfordville, FLBuilt 1946 · S/N 1364N94043Moco Aviation LLC · Moultonborough, NHBuilt 1946 · S/N 1366N94045Stoelt William L · Lynden, WABuilt 1946 · S/N 1368N94047Marsteller Michael A · Lugoff, SCBuilt 1946 · S/N 1370N94060Reedsburg Aviation LLC · Reedsburg, WIS/N 1383N94065Burr Allen H · Oak Island, NCBuilt 1946 · S/N 1388N94068Robertson Malcolm E · El Dorado Springs, MOBuilt 1946 · S/N 1391N94082Ward Roy L · Tell City, INBuilt 1946 · S/N 1405N94084Migliore Richard · Albuquerque, NMS/N 1407N94085Whale Charles R Jr · Kuna, IDBuilt 1946 · S/N 1408N94087Registration Pending · Anderson, CARegistration pendingBuilt 1946 · S/N 1410N94088Johnson David R · Wichita, KSBuilt 1946 · S/N 1411N94093Muchow Charles R · Brookshire, TXBuilt 1946 · S/N 1416N94096Still John D · Greenwood, SCBuilt 1946 · S/N 1419N94099Tr Pegasus Inc · Glenwood, NJBuilt 1946 · S/N 1422N94106Glenn Larry W · Bunn, NCBuilt 1946 · S/N 1429N94109Mccready Kevin · Gettysburg, PAS/N 1432N94113Archer Samuel E Trustee · Independence, ORS/N 1436N94114Sprunger Gary E · Saint Joseph, MIBuilt 1946 · S/N 1437N94115Hurt Paul G · Supply, NCBuilt 1946 · S/N 1438N94116Bentson Lisa F · Las Vegas, NMBuilt 1946 · S/N 1439N94117Burquest Donald A · New Braunfels, TXBuilt 1946 · S/N 1440N94123Croxford Brian · Indianapolis, INBuilt 1946 · S/N 1446N94127Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1450
Back to AD 94-18-04 R1