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.

N33KVWild Blue Aero LLC · O Fallon, ILBuilt 1979 · S/N 28R-7918185N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006N3420QBalladares Charles V · Mandeville, LABuilt 1977 · S/N 28R-7737054N343WPPapa LLC · Eufaula, ALBuilt 1978 · S/N 28R-7837136N3449MCarhart Thomas M · Galesville, WIBuilt 1977 · S/N 28R-7837114N34PTJentone Aviation LLC · Aber Prov Grd, MDBuilt 1974 · S/N 28R-7535029N3511TTippett Daniel W · Heath, OHBuilt 1973 · S/N 28R-7435063N354JHArrow Group 5 LLC · Lake Saint Louis, MOBuilt 1974 · S/N 28R-7435233N3554MWacker Peter K · Marietta, GAS/N 28R-7837123N3559MMoyer Josiah E · Paradise, PABuilt 1978 · S/N 28R-7837124N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126N36024Walla Walla University · College Place, WABuilt 1978 · S/N 28R-7837262N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129N366LCLane Community College · Eugene, ORBuilt 1981 · S/N 28R-8218005N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292N36802United States Air Force- Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837293N36804Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 28R-7837295N36838Sapphire Air LLC · Keystone, COBuilt 1978 · S/N 28R-7837296N3700QGorge Winds Aviation Inc · Fairview, ORS/N 28R-7737047N3704MLacroix Robert Emile Jr · Orlando, FLS/N 28R-7837130N3730MWilcom LLC · Hammond, LABuilt 1978 · S/N 28R-7837133N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174N373PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 28 R 801 8040N3745QBeer Aviation LLC · Santa Rosa Beach, FLS/N 28R-7737058N374CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844175N377LCLane Community College · Eugene, ORS/N 28R-7918120N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200N38200Hauzer Alex · Golden, COBuilt 1977 · S/N 28R-7737083N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098N38457Registration Pending · Phoenix, AZRegistration pendingBuilt 1977 · S/N 28R-7737094N384NDJmfb Enterprises LLC · Concord, NCBuilt 2003 · S/N 2844095N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102N38632Tappan Michael L · Miamisburg, OHBuilt 1977 · S/N 28R-7737103N38655Wensmann Joel · Sartell, MNBuilt 1977 · S/N 28R-7737105
Back to AD 81-11-02 R1