OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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:82-23-01-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:82-23-01-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.

N9090PCatherwood Owen · Eugene, ORBuilt 1966 · S/N 24-4564N9091PGalagan Robert · Lincoln Park, NJBuilt 1966 · S/N 24-4565N9096PGoodman Kenneth M · Eastpoint, FLBuilt 1966 · S/N 24-4572N9097PA T Aviation LLC · Cherokee, IABuilt 1966 · S/N 24-4573N90VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 24-4926N9100PYoder Ernie · Bristol, INBuilt 1966 · S/N 24-4576N9102PFrandsen Brian L · Riverton, UTBuilt 1966 · S/N 24-4578N9103PCarnahan Pamela S · Deer Trail, COBuilt 1966 · S/N 24-4579N9106PMiller Jerry L · Garrison, NDBuilt 1966 · S/N 24-4583N9107PLeigh Malik · Pompano Beach, FLBuilt 1966 · S/N 24-4584N9109PPondo Inc · Wilmington, DEBuilt 1966 · S/N 24-4587N9110PBarron Gerald V · Carmel, CABuilt 1966 · S/N 24-4588N9112PRoesel Aviation LLC · Thomasville, GABuilt 1966 · S/N 24-4590N9114PRegistered aircraftSale reported, pending cancellationBuilt 1966 · S/N 24-4592N9115PHartley Christopher · Fort Worth, TXBuilt 1966 · S/N 24-4593N9116PMaierhoffer Henry F Jr · Sylvania, GABuilt 1966 · S/N 24-4594N9117PRenewable Fuels Consulting Inc · Clear Lake, IABuilt 1966 · S/N 24-4595N9119PChapman Charlie Jr · Lubbock, TXBuilt 1966 · S/N 24-4598N911RKBurnley Christopher · Henderson, NVS/N 30-1184N9127PMiscellaneous Metals LLC · Thaxton, MSBuilt 1966 · S/N 24-4607N9128PPeriman Nicholas James · Waxahachie, TXBuilt 1966 · S/N 24-4608N9129PStocker Glen A · Canyon, TXBuilt 1966 · S/N 24-4609N912JKLysiuk Lance · Andover, CTS/N 244980N912PAlf Ix LLC · Chicago, ILS/N 30-951N9130PFarmer Arnol Jr · Kiana, AKBuilt 1966 · S/N 24-4610N9132PEhrenfelt Linda Mae · Pierre, SDBuilt 1966 · S/N 24-4612N9133PJ&J N2288 LLC · Houston, TXBuilt 1966 · S/N 24-4613N9134PGjdefigo LLC · Gambrills, MDBuilt 1966 · S/N 24-4614N9135PMatthias Michael V · Readlyn, IABuilt 1966 · S/N 24-4615N9137PJackson Thomas A Trustee · Maple Grove, MNBuilt 1966 · S/N 24-4618N9138PSiemering Thomas · Sarasota, FLBuilt 1966 · S/N 24-4619N9140PKing Stephen M · Medford, MABuilt 1966 · S/N 24-4621N9141PSilvabar Air LLC · Springfield, VTS/N 24-4622N9142PErickson Ralph E · Foristell, MOBuilt 1966 · S/N 24-4623N9143PSons Aviation LLC · Moody, ALS/N 24-4624N9144PKober Kelly W · West Chester, PABuilt 1966 · S/N 24-4625N9146PBlack Diamond Aviation LLC · Levelland, TXBuilt 1967 · S/N 24-4629N9147PDesouza Ian · Binghamton, NYBuilt 1966 · S/N 24-4631N9148PJohnson T J H · Franklin, MIBuilt 1966 · S/N 24-4632N914DPGonzalez Ramiro · Lancaster, OHBuilt 1966 · S/N 24-4633N9152PLock Haven 24 LLC · Chandler, AZS/N 24-4637N9153PA&E Aviation LLC · Ruston, LABuilt 1966 · S/N 24-4639N9154PSloan James M Trustee · Grandbury, TXBuilt 1966 · S/N 24-4640N9155PRegistered aircraftBuilt 1966 · S/N 24-4641N9157PN9157p LLC · Mason, MIBuilt 1966 · S/N 24-4643N915BCGentry Jeremiah S · Fort Smith, ARBuilt 1967 · S/N 244673N915HPAnderson Austin C · Washington, DCBuilt 1966 · S/N 24-4371N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650
Back to AD 82-23-01 R1