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.

N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827N9331PAmra Nabil · Chaska, MNS/N 24-4829N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831N9337PWesterfield John III · Birmingham, ALBuilt 1969 · S/N 24-4835N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844N9347PRegistered aircraftBuilt 1969 · S/N 24-4846N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859N9364PTougas William E · Timberlake, NCBuilt 1969 · S/N 24-4864N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869N936RGrandinetti Robert L · Fayetteville, NYBuilt 1967 · S/N 30-1580N9371PBuschmann Robert O Jr Trustee · Prescott, AZBuilt 1969 · S/N 24-4871N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882N9382PRegistered aircraftBuilt 1969 · S/N 24-4883N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887N9390PFlaherty Stephen · El Paso, TXBuilt 1969 · S/N 24-4891N9391PRusty Ventures LLC · Watertown, SDS/N 24-4893N9393PBoucher Bobbi · Fredericksburg, VABuilt 1969 · S/N 24-4895N9394PS A Freight International Inc · San Antonio, TXBuilt 1969 · S/N 24-4897N9395PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1969 · S/N 24-4898N9396PTrom Michael S · Lake Ozark, MOBuilt 1969 · S/N 24-4899N9397PStarritt Mark C · Hollister, CABuilt 1969 · S/N 24-4901N9398PS & T Aviation LLC · Meriden, IABuilt 1969 · S/N 24-4902N939CAMcs Aviation LLC · Larned, KSBuilt 1965 · S/N 24-4222N93BDColeman William R · Jasper, ARBuilt 1967 · S/N 30-1433N9400PKoretsky Aviation LLC · Fairless Hills, PABuilt 1969 · S/N 24-4904N9402PSteinberg Franklyn C III · Flemington, NJBuilt 1969 · S/N 24-4907N9407PHoefle Aviation Inc · Wilmington, DEBuilt 1969 · S/N 24-4912N9409PDormond Brent C · Glendale, CABuilt 1969 · S/N 24-4914N9411PHomsi Joseph · Dover, NJBuilt 1970 · S/N 24-4916N9412PJ L Darr And Son Inc · High Point, NCBuilt 1969 · S/N 24-4917N9414PRegistered aircraftBuilt 1969 · S/N 24-4919N9419PGreene Joseph B · Shafer, MNBuilt 1969 · S/N 24-4925N9427PPaul Burrell Aircraft LLC · Spring, TXBuilt 1969 · S/N 24-4935N9430PBonn Fred H · Jamestown, KYBuilt 1970 · S/N 24-4938N9434PSheehan James A · Newberg, ORBuilt 1970 · S/N 24-4942
Back to AD 82-23-01 R1