OpenAirDocs.org
AD 81-12-06 R1

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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.

N9315PGrady Michael J · Farmington, NMBuilt 1969 · S/N 24-4811N9316PProvost Stephen Nicholas · Saint Louis, MOBuilt 1969 · S/N 24-4812N9317PFutter John H · Whately, MABuilt 1969 · S/N 24-4813N9318PPorter Wayne · Phoenix, AZBuilt 1969 · S/N 24-4814N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036N9321PRegistered aircraftBuilt 1969 · S/N 24-4818N9325PCody 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-4831N9338PDream 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-4846N93486Ablamis Roger · Los Gatos, CABuilt 1973 · S/N 73-31062N934PHRossell Holdings LLC · Astoria, ORBuilt 1974 · S/N 32-7540059N93505Clark Roger D · Lubbock, TXBuilt 1973 · S/N 73-32-120N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854N93541Gibbs Frederick L · Flagstaff, AZBuilt 1973 · S/N 73-32-126N93554Pittman Randy L · Morris, ILBuilt 1973 · S/N 74-31074N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856N93570Huffaker Kenneth Scott · Post, TXBuilt 1973 · S/N 73-32-116N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859N93600Babcock Barry B · Monument, COS/N 73-31061N93657Jewett Lucas D · Helena, MTS/N 76-31123N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869N93710Obrian Brandon · Travelers Rest, SCS/N 73-32-121N9372PBeery 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-4880N9380KResource And Management Group Ltd · Cheyenne, WYFirst renewal noticeBuilt 1976 · S/N 32R-7680211N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882N9382PRegistered aircraftBuilt 1969 · S/N 24-4883N9383RSmith Casey B · Springer, OKS/N 905-14N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885N9385CRobinson Steven Christopher · Enid, OKS/N 32R-7885046N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013N9390PFlaherty Stephen · El Paso, TXBuilt 1969 · S/N 24-4891N9391PRusty Ventures LLC · Watertown, SDS/N 24-4893N9392KDevils Lake Aero LLC · Devils Lake, NDBuilt 1976 · S/N 32R-7680219N9393PBoucher 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-4899
Back to AD 81-12-06 R1