OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,001

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-13-10-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-13-10-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.

N6297FHitchcock Lonnie G · Sparta, TNS/N 337-0297N6298FKubik John A · Hardy, VAS/N 337-0298N6299FLynch Gregory R · Pahrump, NVBuilt 1966 · S/N 337-0299N629LBBachman Aviation LLC · Independence, IABuilt 1979 · S/N R1723063N62NAAdventure Aviation West LLC · Kalispell, MTS/N P3370269N62SGozashti Farid H · Abilene, TXBuilt 1973 · S/N P3370160N62STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1974 · S/N FT3370011N6300BLimit Up LLC · New York, NYBuilt 2001 · S/N 1157N6304KMeadows Michael M · Cypress, TXBuilt 1976 · S/N R1722038N630AMBhh Leasing #3 LLC · Pensacola, FLBuilt 1968 · S/N 337-M0347N630TBRupp Jeffrey · Wauseon, OHBuilt 2011 · S/N 82832N6310FKierstead Andrew R · Alton Bay, NHS/N 337-0310N6311CStarwood Holdings LLC · Seminole, FLBuilt 1978 · S/N 34-7870149N6311FGlasow Eric J · Simpsonville, SCBuilt 1966 · S/N 337-0311N6312FCade Steve DBA · Lopez Island, WABuilt 1966 · S/N 337-0312N6315FSavidge Lenice M · Rogers, ARS/N 337-0315N6325CCurtis Aviation LLC · Derby, KSBuilt 1978 · S/N 28R-7803220N633TCHawkins Alan · Venice, FLFirst renewal noticeBuilt 1978 · S/N 34-7870328N6342FNetherton Ricky D · Blair, OKBuilt 1966 · S/N 337-0342N634GRMurfs Aircraft Sales LLC · Fort Myers, FLBuilt 1996 · S/N 3447023N6352FFletcher John G · Diamondhead, MSS/N 337-0352N6361FTramper Air LLC · Rockford, MIBuilt 1966 · S/N 337-0361N6362FCabral Nicholas · Oldsmar, FLBuilt 1966 · S/N 337-0362N6363KKnoblock Stephen A · Acworth, GABuilt 1976 · S/N R1722041N636RBTurbo Property LLC · Clovis, CABuilt 2010 · S/N 72885N6370FBarrett Thomas M · Superior, WIBuilt 1966 · S/N 337-0370N6372CFair Skies LLC · Seaford, NYBuilt 1978 · S/N 28R-7803223N6382KN6382k LLC · Palm City, FLS/N R1722042N6386FRasys Paul J · Lawton, OKBuilt 1966 · S/N 337-0386N6388CSpray Brothers Aviation LLC · Great Bend, KSBuilt 1978 · S/N 28R-7803225N6396FKing Emily · Laramie, WYS/N 337-0396N6399CRomanowski Mark Steven II · Clay, MIBuilt 1978 · S/N 28R-7803226N639DRYoungblood Curtis · Meridianville, ALBuilt 2002 · S/N 1236N639FAAz Export Corp · Wilmington, DES/N 3449177N639GCCenterline Thrust LLC · Ingleside, TXBuilt 1977 · S/N P3370287N63AHApm Leasing LLC · Casper, WYBuilt 1977 · S/N 34-7870007N6403CSherwood Jeffrey J · Sacramento, CAS/N 28R-7803227N6417KVaro-Real Investments Inc · Visalia, CAS/N R1722044N6424CBlock Howard M · Plymouth, CTBuilt 1978 · S/N 28R-7803230N642CFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R8031155N64408Dematteis James A · Erie, PABuilt 1966 · S/N R1720104N644ACTwin Poles Aviation LLC · East Setauket, NYBuilt 2002 · S/N 3449261N6452KHart Jeffrey D · Eagan, MNBuilt 1976 · S/N R1722045N646DPDavita Aviation LLC · Mars, PABuilt 2011 · S/N 73724N6475CFulton Technology Corp · Caroleen, NCBuilt 1978 · S/N 28R-7803231N648NHVenice Group LLC · Hopkinton, NHS/N P3370063N6494CKaminicki Craig G · Monticello, ARBuilt 1978 · S/N 34-7870161N64CDKerr Martin · Greensburg, PABuilt 2005 · S/N 1589N64DC64dc LLC · Bishop, CABuilt 1977 · S/N 28R-7703397N64NEllegood Michael S · Prescott, AZBuilt 1974 · S/N P3370196
Back to AD 81-13-10 R1