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.

N1663HSecure Uicc Corp · Glen Burnie, MDS/N 28R-7737007N1671HBarth Samuel · Fonda, NYS/N 28R-7737008N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057N16JSMace Terry G · Saint James, MNBuilt 1973 · S/N 28R-7335304N1705MYeager Jacob M · Ignacio, COBuilt 1975 · S/N 28R-7535260N1707HCyberflight Inc · Wilmington, DEBuilt 1977 · S/N 28R-7737010N172NDBlue Max Aero LLC · Miles City, MTBuilt 1988 · S/N 2837007N1746H1746h LLC · La Mirada, CAS/N 28R-7737011N17FVStoltzfus Shawn D · Lancaster, PABuilt 1977 · S/N 28R-7737089N17MSDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 28R-7918152N181DP181dp Aircraft Leasing LLC · Spanish Fork, UTS/N 28R-7335246N1820TCallender Richard · Presque Isle, WIBuilt 1971 · S/N 28R-7135122N187SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 28R-7235139N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018N1940TC140 Co LLC · Milton, FLBuilt 1971 · S/N 28R-7135138N1946TDja Aviation LLC · Middletown, DEBuilt 1971 · S/N 28R-7135140N1952TLeardo Inc · Plano, TXS/N 28R-7135185N1956SRegistered aircraftBuilt 1975 · S/N 28R-7535164N1957TPipers Are Still Better LLC · Carson City, NVBuilt 1971 · S/N 28R-7135177N1960TRay Steven B · Fort Collins, COBuilt 1971 · S/N 28R-7135173N1963TCondor Aero Club Inc · Zelienople, PABuilt 1971 · S/N 28R-7135192N1986HTraining Planes LLC · Tampa, FLS/N 28R-7737022N1989TJ3bar Pilot Services LLC · Garden City, KSBuilt 1971 · S/N 28R-7135203N1993TDenali Management Inc · Encino, CABuilt 1971 · S/N 28R-7135211N1994THelisur USA LLC · Pembroke Pines, FLS/N 28R-7135187N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100N199PGArnett Joshua · Lucas, TXBuilt 1982 · S/N 28R-8218020N199PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-35694N1QABender Edward C Jr · Lansdale, PABuilt 1973 · S/N 28R-7335303N2007MCritz Sue A · El Paso, TXBuilt 1977 · S/N 28R-7837061N200ACKerstetter Michael S · Hewitt, NJBuilt 1969 · S/N 28R-35656N200DWLillian Aviation LLC · Cypress, TXBuilt 2003 · S/N 2844102N200GKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7335287N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113N204NDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 2844070N2055MHarding Lawrence · Santa Monica, CABuilt 1977 · S/N 28R-7837063N2064TClarke Bruce B · Port Angeles, WABuilt 1970 · S/N 28R-7135001
Back to AD 81-11-02 R1