OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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

N4562XVenture West LLC · Mesa, AZBuilt 1975 · S/N 28R-7635078N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098N4583TKeppers Richard W · Alexandria, VABuilt 1972 · S/N 28R-7235099N4586XMccardle Michael L · Houston, TXBuilt 1975 · S/N 28R-7635086N4590TOdonald John C · Greenville, MIBuilt 1972 · S/N 28R-7235102N4594XAdventure Ventures LLC · Salem, CTBuilt 1975 · S/N 28R-7635088N4597TArsenault Ronald L Jr · Newton, ALBuilt 1972 · S/N 28R-7235104N460KKBeard Merwin R · Houston, TXBuilt 1979 · S/N 28R-8018005N463RNDave Aviation LLC · Naperville, ILBuilt 1971 · S/N 28R-7135050N4641FCrosswinds Flying Club Inc · Bloomington, ILBuilt 1976 · S/N 28R-7635431N4665FManzani Kelly · Temecula, CABuilt 1976 · S/N 28R-7635407N468PMEarspasm LLC · Brooklyn, NYBuilt 1972 · S/N 28R-7335041N46UTVon Schmidt Gordon D · Waretown, NJBuilt 1973 · S/N 28R-7435068N4711YAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28R-7335424N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158N47337Beatty William Keith · Lakeland, FLBuilt 1977 · S/N 28R-7737159N47484Sugarbaker Stephen J · Rocklin, CABuilt 1977 · S/N 28R-7737165N47494Valiair Lc Trustee · Casper, WYS/N 28R-7737166N47497Alpha Arrow Flying LLC · Iowa City, IABuilt 1977 · S/N 28R-7737168N47498Strobel John D · Baltimore, MDBuilt 1977 · S/N 28R-7737169N47680New Mexico Flying Eagle DBA · Tucson, AZBuilt 1977 · S/N 28R-7737173N47700Indian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 28R-7837001N47723Six Drew · Clinton, OHS/N 28R-7837002N47738Coady Thomas J · Wausau, WIBuilt 1977 · S/N 28R-7837003N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008N4792TBrooks 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-7235110N479RRFlight 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-7235132N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159
Back to AD 81-11-02 R1