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.

N8094CPowell David J · Endicott, NYBuilt 1975 · S/N 28R-7635130N8098RSomerset Air Service Inc · Bedminster, NJBuilt 1979 · S/N 28R-8018003N809MBerkshire Aviation Enterprises LLC · Great Barrington, MABuilt 1977 · S/N 28R-7837015N80KARowe Andrew · Palmdale, CABuilt 1972 · S/N 28R-7235166N80KPMacstam Air LLC · Robins, IABuilt 1980 · S/N 28R-8018090N80MLBishop Jack · Sabina, OHBuilt 1980 · S/N 28R-8018007N80UMGoodman Christopher W · Hammond, LABuilt 1979 · S/N 28R7918090N8104YHawkins Jared · Fostoria, OHBuilt 1979 · S/N 28R-8018013N8108MBeach Eric S · New Port Richey, FLBuilt 1979 · S/N 28R-8018006N8109DLichtsteiner Patrick H · Shepherdsville, KYBuilt 1979 · S/N 28R-8018014N8109GCamous Alain · Sunrise, FLS/N 28R-8018015N8109RHeagy Stephen M · Hillsboro, ORBuilt 1979 · S/N 28R-8018016N8116QShulins Paul · Wickenburg, AZBuilt 1979 · S/N 28R-8018017N8116RJimmy & Ryans Totally Awesome Airplane Ventures Lc · Crete, ILBuilt 1979 · S/N 28R-8018018N8119ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 28R-8231031N8139HAmerican Heritage Aviation Inc · Peachtree City, GAS/N 28R-8018025N813NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 2837044N8140EProppe Karl H · Needham, MABuilt 1982 · S/N 28R-8218012N814NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 2837045N81529Gobeli Michael T · East Lyme, CTBuilt 1980 · S/N 28R-8018036N8158PHuo Keith Yuke · Las Vegas, NVBuilt 1980 · S/N 28R-8018041N8164ZOrtiz Celestino Jose G · Fort Worth, TXBuilt 1980 · S/N 28R-8018047N8175CYates Trucking Inc · Quartz Hill, CABuilt 1975 · S/N 28R-7635132N8182MAbbassi Isslaam S · Thorp, WABuilt 1980 · S/N 28R-8018058N8182QJobin Lyle S · Saint Augustine, FLBuilt 1980 · S/N 28R-8018059N8183ZDewitt Jay Steven · China Spring, TXBuilt 1980 · S/N 28R-8018060N8184CRouse Michael R · Wilson, NCBuilt 1975 · S/N 28R-7635133N81898Zanetti James D · Rock Springs, WYBuilt 1980 · S/N 28R-8018064N820HGGeorgia Aviation Authority · Eastman, GABuilt 2004 · S/N 2844114N820JKEkins Sean A · Mesa, AZBuilt 1973 · S/N 28R-7335334N820PJGoetzman Chad Joseph · North Myrtle Beach, SCBuilt 1972 · S/N 28R-7235021N8212QGriffin Terry R · Rock Hill, SCBuilt 1980 · S/N 28RT-8018070N8223BRas Aviation LLC · Elyria, OHBuilt 1980 · S/N 28R-8018080N8223CCurless Timothy A · Demotte, INBuilt 1975 · S/N 28R-7635134N8227VGrabowski Matt · Selma, CABuilt 1980 · S/N 28R-8018085N8229YLee Daniel B · Ajo, AZBuilt 1980 · S/N 28R-8018086N822AGQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 28R-7918142N822JSN822js LLC · Norcross, GABuilt 1973 · S/N 28R-7335425N8231YTravis Michael · Burns, ORBuilt 1980 · S/N 28R-8018087N8250VCorea Darren T · Galveston, TXBuilt 1980 · S/N 28R-8018099N8265SThunderbird Aircraft Co · Bloomington, MNBuilt 1980 · S/N 28R-8118001N8277AAlfred Michael R · Camarillo, CABuilt 1980 · S/N 28R-8118007N8279WBlue Cat Aviation LLC · Orinda, CAS/N 28R-8118010N82821Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1980 · S/N 28R-8118014N82823Stokes William J · Richland, WAFirst renewal noticeBuilt 1980 · S/N 28R-8118016N82859Schoeler George A · Ocala, FLBuilt 1980 · S/N 28R-8118018N8286BHigh Altitude Ministries LLC · Blythewood, SCBuilt 1980 · S/N 28R-8118019N8288LFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1980 · S/N 28R-8118011N82954Phoenix Air LLC · Hemet, CABuilt 1980 · S/N 28R-8118025N8301CBeach Aero LLC · Virginia Beach, VABuilt 1975 · S/N 28R-7635144
Back to AD 81-11-02 R1