OpenAirDocs.org
AD 82-06-11 R1

Registered aircraft · 2,375

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-06-11-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-06-11-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.

N38DSMiller Ronald L · Jackson, WYS/N 28R7931177N38TXGlinn Andrew T · Keystone, NEBuilt 1977 · S/N 28R-7703297N38WJFerguson Scott D · Valparaiso, INBuilt 1975 · S/N 28R-7535327N3904XMoore Jeremy E · Baton Rouge, LABuilt 1975 · S/N 28R-7535347N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350N3914XLechene Aviation LLC · Indiana, PABuilt 1975 · S/N 28R-7535351N3918XHorton Gregory L · Moorpark, CAS/N 28R-7703001N3920XBennett Barry B · El Cajon, CABuilt 1975 · S/N 28R-7535352N3921XBurger Paul D · Cypress, TXBuilt 1975 · S/N 28R-7535353N3923XFerriero Bruce C · Danvers, MABuilt 1975 · S/N 28R-7535354N3928MSalter James A · San Luis Obispo, CABuilt 1978 · S/N 28R-7803201N3928XVanness Aviation LLC · Lawton, NDBuilt 1975 · S/N 28R-7535355N3932XCarbon Six LLC · San Diego, CAS/N 28R-7535356N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297N39476Neal John W · Pt Pleas Bch, NJBuilt 1978 · S/N 28R-7803348N39477Marti Michael · Kasson, MNBuilt 1978 · S/N 28R-7803349N3949MMatthews Devon · San Jose, CABuilt 1978 · S/N 28R-7803204N3949XBlue Ridge Flyers · Leesburg, VABuilt 1975 · S/N 28R-7535365N39513Vitale F Richard · Colts Neck, NJBuilt 1978 · S/N 28R-7837300N39535Flight Services Inc · Headland, ALBuilt 1978 · S/N 28R-7837302N39547Workman Dean B · Newport, RIBuilt 1978 · S/N 28R-7837303N39568James David Wayne · Odessa, TXBuilt 1978 · S/N 28R-7803355N3956XHuth William L · Gulf Breeze, FLBuilt 1975 · S/N 28R-7535366N3957FSeipp Stephen C · Laurel, DEBuilt 1976 · S/N 28R-7635392N39611Boon & Company Aviation LLC · Charlotte, NCBuilt 1978 · S/N 28R-7803357N39646Icpc Craft LLC · Fremont, CABuilt 1978 · S/N 28R-7803358N39718Wood Allan W · Santa Fe, NMBuilt 1978 · S/N 28R-7803359N3972XSoares Jeffrey A · Aptos, CABuilt 1975 · S/N 28R-7535378N3982XSauve Tiffany A · Racine, WIBuilt 1975 · S/N 28R-7535382N3988XMohlenkamp Jami S · Erie, COBuilt 1975 · S/N 28R-7635002N3991MStaruh Donald E · Pueblo, COBuilt 1978 · S/N 28R-7803211N3996FGrim William S · Kingwood, TXBuilt 1976 · S/N 28R-7635394N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126N40010Sain Ricky F · Vale, NCS/N 28R-7737127N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128N40046Ponce Annabelle S Brack · Zephyr Cove, NVBuilt 1977 · S/N 28R-7703296N40065Aldridge Raymond · Moultrie, GABuilt 1977 · S/N 28R-7703302N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059N4013QSegura Huey F Jr · Lafayette, LABuilt 1977 · S/N 28R-7703118N402DSDelaware State University · Dover, DEBuilt 1975 · S/N 28R-7635004N40441Dozier Todd A · Fairfax Station, VAS/N 28R-7703306N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113N4065QZajdel Edwin J Jr · Ocean City, MDBuilt 1977 · S/N 28R-7737060N4066QDmb Aviation LLC · Oakland, MIS/N 28R-7703120N40679Skipper Consulting LLC · Athens, ALBuilt 1977 · S/N 28R-7737132N4068QAerotechnics Aviation Inc · GloucestershireBuilt 1977 · S/N 28R-7703121
Back to AD 82-06-11 R1