OpenAirDocs.org
AD 2001-17-26 R1

Registered aircraft · 293

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:2001-17-26-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:2001-17-26-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.

N686TXYour Jet LLC · Wilmington, DEBuilt 2004 · S/N 258686N68CBCracker Barrel Old Country Store Inc · Lebanon, TNBuilt 1999 · S/N 258453N694ESMonfort Aviation LLC · Eaton, COBuilt 2004 · S/N 258694N6NRSdi Aviation LLC · Rhinelander, WIBuilt 2004 · S/N 258701N704JMCnhi LLC · Montgomery, ALBuilt 1998 · S/N 258367N705BBMo-Az LLC · Saint Louis, MOBuilt 2006 · S/N 258765N707BMLft Properties LLC · Mayfield Heights, OHBuilt 2005 · S/N 258730N707JQPinnacle Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258703N709LPPilgrim Air LLC · Van Nuys, CABuilt 1997 · S/N 258329N710HRAsf Aviation LLC · Cortlandt Manor, NYBuilt 1999 · S/N 258390N715LALongbow Aviation LLC · Fernandina Beach, FLBuilt 1999 · S/N 258441N716DBCervenka Debra A · Santa Rosa Beach, FLBuilt 2002 · S/N 258568N717KVN717kv LLC · Wilmington, DEBuilt 1999 · S/N 258449N718RRMac 800xp LLC · Wilmington, DEBuilt 1999 · S/N 258428N719HGFlightworks Inc · Kennesaw, GABuilt 2000 · S/N 258488N71AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 258654N724JLAmeri Hawk Investments LLC · Lorton, VABuilt 2006 · S/N 258772N726LCN726lc LLC · Amarillo, TXBuilt 1998 · S/N 258349N729ATN88ca III LLC · Stuart, FLBuilt 1999 · S/N 258402N72FCAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258519N72HAMcn Aviation Partners LLC · Charlestown, INBuilt 2000 · S/N 258503N740TTValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 258644N745MCMiradair LLC · Lake George, NYBuilt 2002 · S/N 258593N746TXSierra Aviation Holdings LLC · Colorado Springs, COBuilt 2005 · S/N 258746N749WWSmf Ohio LLC · Lakewood, NJBuilt 2001 · S/N 258500N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587N771FMCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2002 · S/N 258591N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378N789HAClark County Jets LLC · Sellersburg, INBuilt 1998 · S/N 258354N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708N799SN143bl LLC · Hixson, TNBuilt 2002 · S/N 258588N79TSTasair LLC · Minocqua, WIBuilt 2001 · S/N 258511N800EASalt Whistle LLC · Newark, DEBuilt 2002 · S/N 258582N800GNJaunt Jet LLC · Spring, TXBuilt 1998 · S/N 258372N800LQAdc Aviation LLC · Birmingham, ALBuilt 2001 · S/N 258551N800MAMarco Aviation LLC · Nazareth, PABuilt 1998 · S/N 258369N800NGClear Horizons LLC · Greenwood Village, COBuilt 2001 · S/N 258549N800NJGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 2000 · S/N 258483N800PEFour C Air Inc · Delano, CABuilt 2000 · S/N 258508N800PLN800pl LLC · Fort Lauderdale, FLS/N 258696N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678N800TLN800tl LLC · Wilmington, DEBuilt 1998 · S/N 258394N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577N800UWUniform Whiskey Holdings LLC · Opa Locka, FLBuilt 1998 · S/N 258395N800WDV1vr LLC · Wilmington, DEBuilt 1997 · S/N 259052N800WFVarsity Aviation LLC · Martinsburg, PABuilt 2005 · S/N 258728N800WWPnw Transport LLC · Tucson, AZBuilt 2004 · S/N 258661N800XMFlyteme Aviation LLC · Fort Pierce, FLBuilt 1999 · S/N 258414N800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 258283
Back to AD 2001-17-26 R1