OpenAirDocs.org
AD 2017-23-06

Registered aircraft · 1,090

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-23-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-23-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.

N100ACSmith Vicars & Co LLC · Charlottesville, VABuilt 2002 · S/N 5546N101KFTravers 6 LLC · Chesterfield, MOS/N 5564N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354N111CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 5192N116HLWorld Tech Aviation LLC · Valencia, CAS/N 5113N118MTOne World Aviation 118 LLC · Atlanta, GAS/N 5077N125JJNeves LLC · Elizabethtown, KYS/N 5412N131EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15217N132EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15219N133EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15222N134EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15223N134WM560 Company Inc · Anchorage, AKBuilt 1997 · S/N 5340N135EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15225N135SMStonegate Leasing 2020 LLC · Natick, MABuilt 2000 · S/N 5444N136EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15226N137EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15227N138EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15235N139LJGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1988 · S/N 5025N141SHLead And Steel 4 LLC · Fountain Valley, CABuilt 1997 · S/N 7206N144MHW Hughes Aviation LLC · Stanton, TXBuilt 1993 · S/N 5135N146PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15146N147PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15147N150BBMs Hawker LLC · Farmington Hills, MIBuilt 2000 · S/N 5470N153PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15153N156RCWarehouse Management Inc · Cincinnati, OHBuilt 2000 · S/N 5446N15LNNeal Air LLC · Merced, CABuilt 2001 · S/N 5509N161JGIal Corp · Lewes, DEBuilt 1988 · S/N 5028N161PBTeam Aero LLC · Olathe, KSS/N 5069N161PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15161N162PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15162N166PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15166N16KBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5066N170PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15170N170XYSwiflite Aircraft Corp · Houston, TXBuilt 2008 · S/N 17000241N17156Bank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 7156N176PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15176N177RSAng USA II LLC · Naples, FLBuilt 2006 · S/N 17000112N181GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15204N181PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15181N182GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15175N183GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15209N184GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15169N185GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15185N186GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15165N186PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15186N187GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15180N187PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15187N188CRHelianthus Aviation LLC · Las Vegas, NVBuilt 2001 · S/N 5504N18RCBrr Aviation LLC · Houston, TXBuilt 1996 · S/N 5315
Back to AD 2017-23-06