OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,752

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.

N2071MBudd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 28R-7837064N2072TAshby Darrell · Elko, MNBuilt 1970 · S/N 28R-7135016N2073MHanel David Matthew · Suwanee, GAS/N 28R-7837065N2073TMcguire Guy D · Stevensville, MDBuilt 1970 · S/N 28R-7135017N2076TKaplan Ross H · Pompano Beach, FLBuilt 1970 · S/N 28R-7135020N2077TThoendel Joshua R · O' Neill, NEFirst renewal noticeBuilt 1970 · S/N 28R-7135021N2078ARyan John T · Salina, KSBuilt 1978 · S/N 28R-7837315N2078TMavity Michael D · Phoenix, AZBuilt 1970 · S/N 28R-7135022N2079TCraig James A · Salt Lake City, UTBuilt 1970 · S/N 28R-7135023N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029N2086TEllis Amy E · Santa Rosa, CABuilt 1970 · S/N 28R-7135030N2089TBeusekom Jeremy Van · Eden Prairie, MNBuilt 1970 · S/N 28R-7135033N2091WDestefano Patrick · Adamsville, TNS/N 28R-7918076N2092TCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1971 · S/N 28R-7135037N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044N2101TTraylor John M · Helena, ALBuilt 1971 · S/N 28R-7135045N2103MMontgomery William A · El Paso, TXBuilt 1977 · S/N 28R-7837066N2104TAllison Jack A · Orangevale, CABuilt 1971 · S/N 28R-7135048N2105THolt Dennis A · Gilbertsville, PABuilt 1971 · S/N 28R-7135051N2109TCarver Aero LLC · Muscatine, IABuilt 1971 · S/N 28R-7135055N210SPCooper Mark D · Colchester, CTBuilt 1979 · S/N 28R-7918048N2110TN2110t LLC · Columbus, OHBuilt 1971 · S/N 28R-7135056N2110WRegal Aero LLC · Agua Dulce, CABuilt 1979 · S/N 28R-7918078N2113T10 Mile Final 33 LLC · Charleston, SCBuilt 1971 · S/N 28R-7135058N2114TPulka Michael R · Yardley, PABuilt 1971 · S/N 28R-7135060N2116TBeshai Charles John · Huntington Beach, CABuilt 1971 · S/N 28R-7135061N2117TCruce Aviation LLC · Marquette Heights, ILBuilt 1971 · S/N 28R-7135062N2117USouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 28R-7918066N2118NBillberry Daniel · Chula Vista, CABuilt 1979 · S/N 28R-7918037N2119TTyler Kenneth A · Napa, CABuilt 1971 · S/N 28R-7135064N211VMGuardian Flight LLC · South Jordan, UTBuilt 1989 · S/N 2837030N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068N2127TGeiger Glenn M · Cincinnati, OHBuilt 1971 · S/N 28R-7135070N2129TSebesta Arthur J II · Winchester, KYBuilt 1971 · S/N 28R-7135072N212BMLeaseair LLC · Wilmington, DES/N 28R-7235136N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139N2136EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R-7918002
Back to AD 81-11-02 R1