OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N9345YDana Aviation LLC · Mesa, AZBuilt 1960 · S/N D-6549N9347YNelson Forrest W · Amherst, NHBuilt 1960 · S/N D-6552N934DZellers Clyde E · Springfield, ILBuilt 1956 · S/N D-4670N934VFinke Wailes · Charleston, MSBuilt 1975 · S/N D-9739N9358YBruce Mkristo · Mesa, AZBuilt 1960 · S/N D-6559N9360YZapata Joseph B · Deland, FLBuilt 1960 · S/N D-6476N9366YMoss Douglas M Trustee · Reno, NVBuilt 1960 · S/N D-6509N9371QAshe Industries LLC · Murrieta, CABuilt 1972 · S/N D-9309N9381YGlotzer Steven H · Scottsdale, AZBuilt 1960 · S/N D-6576N9387YGiordano James J · Livonia, MIBuilt 1960 · S/N D-6582N93VTLidner Mark H · Sun City, AZBuilt 1970 · S/N D-9155N9400QPrealow Scottie T · Lubbock, TXBuilt 1970 · S/N D-9163N9401YRoper Eric William Andrade · Henderson, NVS/N D-6578N9405SHackbarth Dean R · Henderson, NVBuilt 1965 · S/N D-8010N9406SMorales Harry · Hilton Head Island, SCBuilt 1965 · S/N D-8011N9407SRobinett Barton L · Frankston, TXBuilt 1965 · S/N D-8012N9409YHamre Jeffrey · Leonard, NDFirst renewal noticeBuilt 1961 · S/N D-6631N9410SMoore James F · Higden, ARS/N D-8013N9410YCapital Framing LLC · Greensburg, KYS/N D-6591N9412SSamels Randy · Simi Valley, CAS/N D-8014N9416YSneed John A · Fort Morgan, COBuilt 1960 · S/N D-6594N9417YRegistration Pending · Decatur, TXRegistration pendingBuilt 1960 · S/N D-6595N9418YEnloe Robert J Jr · Naples, FLBuilt 1960 · S/N D-6596N941AChalk 2 Inc · Apple Valley, CABuilt 1965 · S/N D-7865N941ALWatson Alfred L · Bucklin, MOS/N D-6423N9420SBaumann James R · Muskogee, OKS/N D-8015N9421SFugate Kirk A · El Dorado Springs, MOBuilt 1965 · S/N D-8017N9422SWindwalker Adventures LLC · Scottsdale, AZBuilt 1965 · S/N D-8020N9423STlc Aero LLC · Magnolia, TXBuilt 1965 · S/N D-8018N9424YDurham Dusty Lowell · Lubbock, TXBuilt 1960 · S/N D-6603N9426YMy Pilot Ltd · Northridge, CAS/N D-6605N9427YKing Rodney R · Lucedale, MSBuilt 1960 · S/N D-6601N9428YFlying W LLC · Ridgeland, SCBuilt 1960 · S/N D-6606N9430QHoyt Stuart T · Raleigh, NCBuilt 1972 · S/N D-9316N9430YGcw Aero LLC · Naples, FLBuilt 1960 · S/N D-6609N9431SBurgdorf Dale A · Plano, TXBuilt 1965 · S/N D-8021N9431YSims Steve · Greenville, TXBuilt 1960 · S/N D-6610N9435YGailey Henry S · Elberton, GAS/N D-6613N9436YRominger Kent V · Cottonwood Heights, UTBuilt 1960 · S/N D-6614N9437YKramer Kaleb R · Henderson, TXBuilt 1960 · S/N D-6615N9439SDocs Huckleberry LLC · Cornell, WIS/N D8025N9440QKatz Alan E · Hopkinton, MABuilt 1972 · S/N D-9319N9440YWhite Travis W · Charleston, SCBuilt 1960 · S/N D-6621N9441YBennett Innocent Rwagasore · San Marcos, TXS/N D-6623N9445YSkpy LLC · Kalispell, MTBuilt 1961 · S/N D-6629N944QRoach Terrance J · Little Falls, MNBuilt 1961 · S/N D-6818N944RMKrol Matthew D · Hideaway, TXBuilt 1965 · S/N D-8026N9450SDakota Sierra LLC · Horace, NDBuilt 1966 · S/N D-8045N9450YBatchelor Sarah Hall · Decatur, ALS/N D-6624N9455SBlythe Edward A · Dallas, TXBuilt 1966 · S/N D-8050
Back to AD 94-20-04 R2