AD 2017-02-06

Registered aircraft · 201

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

N80MALsc Construction Inc · Perris, CAS/N 31T7720043N818SFSierra Foxtrot LLC · Dodge City, KSBuilt 1980 · S/N 31T-8004018N819SWWho Dey LLC · Savannah, GABuilt 1981 · S/N 31T-8104059N81MSCapital Craft LLC · Wilmington, DES/N 31T-8104007N824CBHelfrick Edward W Jr · Elysburg, PABuilt 1981 · S/N 31T-8104052N827LPSagamore Aviation LLC · Lewes, DES/N 31T-7904048N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034N83CACheyenne 2 LLC · Colonial Heights, VABuilt 1980 · S/N 31T-8020072N83MGWatkins Jon Trustee · Florence, ORBuilt 1981 · S/N 31T-8104047N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030N901TKAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 31T-7904028N90FSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 31T-8020011N90VMJ & B Leasing Inc · Springfield, MOBuilt 1981 · S/N 31T-8104031N910AGCreative Marketing Associates Inc · Saint Petersburg, FLBuilt 1984 · S/N 31T-8004041N910HGTiffin Aire Inc · Tiffin, OHS/N 31T-7400009N910JPRegistered aircraftBuilt 1977 · S/N 31T-7820004N913NCDeweese Michel J · Rockvale, TNBuilt 1981 · S/N 31T-8120044N914ASRed Speakers LLC · Newark, DEBuilt 1981 · S/N 31T8104066N916RTAasjng LLC · Holdrege, NEBuilt 1981 · S/N 31T-8166041N917TPAerial LLC · Kalispell, MTBuilt 1982 · S/N 31T8104068N918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 31T-7904025N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020N9237YIal Corp · Lewes, DES/N 31P-8414022N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025N9262YTwin Star Montana LLC · Kalispell, MTBuilt 1984 · S/N 31P-8414033N9266YTiffin Aire Inc · Tiffin, OHS/N 31T-1104008N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037N93SHBasin Air LLC · Mattawa, WAFirst renewal noticeS/N 31T-7904029N944GMSix States Rentals Inc · Union, MOBuilt 1978 · S/N 31T-7904005N950CTJack Of Queens LLC · Afton, OKBuilt 1977 · S/N 31T-7720069N950SACrop Dusters LLC · Maurice, IABuilt 1981 · S/N 31T-8166028N96MAGoldielochs Air LLC · Annapolis, MDS/N 31T-7804005N970PSKrech Greg Trustee · Huron, SDBuilt 1979 · S/N 31T-8020023N977GUS Nameplate Co · Mount Vernon, IABuilt 1981 · S/N 31T-8104065N980CATlh Enterprises Inc · Corsicana, TXBuilt 1980 · S/N 31T-8104010N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011N98FAHigher Purpose Aviaiton LLC · Spring Lake, MIBuilt 1980 · S/N 31T-8004028N98TGBell Scott W · Greeley, COS/N 31T-7904027N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006
Back to AD 2017-02-06