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.

N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751N9254PMeyer Aviation LLC · South St Paul, MNBuilt 1968 · S/N 24-4752N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768N9269PRegistered aircraftBuilt 1968 · S/N 24-4769N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774N9276PHansen Stephen J · Redmond, WAS/N 24-4776N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780N9282PCampbell Paul · Glade Spring, VABuilt 1968 · S/N 24-4782N9284PDickinson Malcolm · Stamford, CTBuilt 1968 · S/N 24-4784N9285PStumpf Bernard L · Westerly, RIBuilt 1968 · S/N 24-4785N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789N9292PRegistered aircraftBuilt 1968 · S/N 24-4791N9293PCenterline Holdings Inc · Camden, DEBuilt 1968 · S/N 24-4792N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796N92BHHeydorff Stephen F Trustee · Sierra Madre, CABuilt 1969 · S/N 30-1852N92EEGw Aero LLC · Arnold, MDBuilt 1959 · S/N 24-1668N92NEAnderson Aviation LLC · Bulverde, TXBuilt 1964 · S/N 30-459N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799N9308PExecutive Enterprise Solutions LLC · Mount Pleasant, SCBuilt 1969 · S/N 24-4804N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809N9315PGrady 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-4814N9321PRegistered aircraftBuilt 1969 · S/N 24-4818
Back to AD 82-23-01 R1