OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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:2011-07-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-13')
  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.

N112EFCommander 112a LLC · Shelburne, VTBuilt 1975 · S/N 309N112GTGallagher Aircraft Services LLC · Dawson, PABuilt 1974 · S/N 235N112HTTaffel Sherman D DBA · Columbia, MDBuilt 1978 · S/N 13254N112JASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 13182N112LBLegvold Christopher Paul · Green Cove Springs, FLBuilt 1976 · S/N 13058N112MGTalley Miriam S · San Antonio, TXBuilt 1973 · S/N 42N112RCStraubel Investments Inc · Egg Harbor, WIBuilt 1973 · S/N 79N112SJSuchomel Chase E · North Saint Paul, MNS/N 38N112TCGrass Brian Shane · Ocala, FLBuilt 1978 · S/N 13266N112TSLongo Curtis M · Crossville, TNBuilt 1979 · S/N 13306N112WNEvans William M · Nipomo, CABuilt 1974 · S/N 169N1137JDaugusta Richard J · Lexington, MAS/N 137N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N114ADBailey Walter A III · Cincinnati, OHBuilt 1998 · S/N 20020N114ANHake Scott W · Swoope, VABuilt 1978 · S/N 14396N114ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 14619N114AWCameron Hugh R · Gainesboro, TNBuilt 1976 · S/N 14095N114BShankle Michael L · Culpeper, VABuilt 1993 · S/N 14588N114BLLoose David C · Blanco, TXBuilt 1976 · S/N 14003N114BMJaswal Faisal · La Conner, WABuilt 1976 · S/N 14082N114BTMidnight Black International LLC · Helena, MTS/N 14221N114BWDodson International Parts Inc · Rantoul, KSS/N 14541N114BXRcs Aviation LLC · Indian Trail, NCBuilt 1992 · S/N 14543N114CECommander Air LLC · Purcellville, VABuilt 1996 · S/N 14640N114CGUnited Aviation LLC · Whitehall, PABuilt 1995 · S/N 14628N114CTTairex Inc · Wilmington, DES/N 14413N114DFNorthwoods Distribution Services Inc · Rhinelander, WIBuilt 1978 · S/N 14360N114DPMatson Kenneth A · Highland Park, ILS/N 20027N114DTBarrett Brett A DBA · Indian Rocks Beach, FLBuilt 1993 · S/N 14576N114DWLayman Nathan L · Hudson, WIBuilt 1978 · S/N 14408N114EEEngstrom Eric R · Eastover, NCBuilt 1978 · S/N 14357N114FFCoastal Development Group LLC · Boca Grande, FLBuilt 1976 · S/N 14012N114GGXp Consulting LLC · Grand Prairie, TXS/N 14529N114GTEnders Richard A · San Bernardino, CABuilt 1976 · S/N 14130N114HHHuddleston H Glenn · San Antonio, TXS/N 14209N114HPDolanair LLC · Coal Valley, ILBuilt 1978 · S/N 14370N114JAWright Richard D · Acworth, GABuilt 1978 · S/N 14365N114JGMack Phillip B · Tampa, FLBuilt 1995 · S/N 14634N114JTVanbeek Donald Eugene · Tualatin, ORBuilt 1976 · S/N 14104N114KR H Welsh LLC · Crescent City, FLBuilt 1979 · S/N 14519N114KJRegistered aircraftFirst renewal noticeBuilt 1995 · S/N 14630N114KKMckissick Vern L III · Harrisburg, PABuilt 1977 · S/N 13163N114KLKaruppannan Venkatachalam · Troy, MIBuilt 1978 · S/N 14427N114LWAmes Thomas E · Yuma, AZBuilt 1977 · S/N 14275N114MBCrew Andrew P · Chester, CTBuilt 1976 · S/N 14084N114MDUrsic Albert J · Minden, NVS/N 14033
Back to AD 2011-07-13