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.

N47632Famalette Christopher · Havre De Grace, MDBuilt 1977 · S/N 28R-7703367N47642Wes Hughes Corporation · Waldron, KSBuilt 1977 · S/N 28R-7703413N47662Milo Michael E · Evansville, WYS/N 28R-7703417N47680New Mexico Flying Eagle DBA · Tucson, AZBuilt 1977 · S/N 28R-7737173N47681C Mf Inc · Bloomington, ILBuilt 1977 · S/N 28R-7703421N47682Byerly James · Virginia Beach, VABuilt 1977 · S/N 28R-7703422N476JBArchipelago Group LLC · Alexandria, VABuilt 1977 · S/N 28R-7703419N47700Indian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 28R-7837001N47707Stateler Mickey S · Fort Worth, TXS/N 28R-7803001N47709Bedy David P · Albuquerque, NMBuilt 1977 · S/N 28R-7803002N47723Six Drew · Clinton, OHS/N 28R-7837002N47726Pier To Plateau Aviation Services LLC · Wilmington, DES/N 28R-7803005N47728Jr Aircraft Services LLC · Oxford, MIBuilt 1977 · S/N 28R-7803006N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003N47739Tnl Management LLC · Cullman, ALBuilt 1977 · S/N 28R-7803008N47740Media Stew LLC · Carson City, NVBuilt 1977 · S/N 28R-7803009N47742Jmd Enterprises LLC · Thompsons Station, TNBuilt 1977 · S/N 28R-7803011N47761Engholm Jeffrey H · Bauxite, ARBuilt 1977 · S/N 28R-7803012N47763Premier Management Co · Mobridge, SDBuilt 1977 · S/N 28R-7803014N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030N47805Premier Aviation LLC · Sioux Falls, SDS/N 28R-7803016N47810Nrg Systems N W LLC · Gresham, ORBuilt 1977 · S/N 28R-7803019N47826Rogerson Andrew C · Kingsland, TXBuilt 1977 · S/N 28R-7803021N47827Alford James L · Mckinney, TXBuilt 1977 · S/N 28R-7803022N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006N47842S&L Farm And Ranch LLC · Roseburg, ORS/N 28R-7803025N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008N47874Matthews John M · Mount Pleasant, TXBuilt 1977 · S/N 28R-7803032N47891Pearson Joe D · Boise, IDBuilt 1977 · S/N 28R-7803035N47912Maxey Russell J · Midland, TXFirst renewal noticeS/N 28R-7803037N4792TBrooks Donald D · Baton Rouge, LABuilt 1972 · S/N 28R-7235109N47945Countee Roger Brendan · Los Angeles, CABuilt 1977 · S/N 28R-7837018N4795TCammack Van R Jr · Willow Park, TXBuilt 1972 · S/N 28R-7235110N47987Mongo Corp · Santa Fe, NMBuilt 1977 · S/N 28R-7803052N479RRFlight World Inc · San Juan, PRS/N 28R-7918065N47SSandlapper Aviation Of De Inc · Bennington, VTBuilt 1970 · S/N 28R-35769N4802TSmith Terry G · Kamuela, HIS/N 28R-7235111N4816TBulldog Air LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235114N4817TJoly Paul A · Henderson, NVBuilt 1972 · S/N 28R-7235115N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437N4831TPower Flow Systems Inc · Daytona Beach, FLBuilt 1972 · S/N 28R-7235120N4846TChurchill Scott W · Le Sueur, MNBuilt 1972 · S/N 28R-7235125N4874TSmith Richard R Sr · Wellington, NVS/N 28R-7235128N4884TRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1972 · S/N 28R-7235131N4892TTwo Tango Aviation LLC · Plant City, FLBuilt 1972 · S/N 28R-7235132N48WRRasquinha Warren · Sanford, FLBuilt 1977 · S/N 28R-7703355N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159N4924FStolee Aviation LLC · Bristol, PAS/N 28R-7635442
Back to AD 82-06-11 R1