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.

N265JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 2004 · S/N 258699N26TCAcme Nite LLC · Nashville, TNBuilt 2001 · S/N 258521N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N279CFJ Jets Inc · Dover, DES/N 258642N285XPAviation Fjaf LLC · Davie, FLBuilt 1995 · S/N 258285N298WB45 Srl Inc · Houston, TXBuilt 2000 · S/N 258476N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N300CQHawker 4 LLC · Jensen Beach, FLBuilt 2001 · S/N 258555N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N310EJZenodro At Tranquility Aviation LLC · Clermont, FLBuilt 2006 · S/N 258767N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N316MFMf Property Management LLC · Hattiesburg, MSS/N 258314N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273N339AVKmwflight LLC · Wilmington, DEBuilt 1994 · S/N 258255N33BCSworks Aviation LLC · Chicago, ILBuilt 1996 · S/N 258292N33RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 258466N343SCMtj Aviation LLC · Mooresville, NCBuilt 1998 · S/N 258365N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334N353JABasler Turbo Conversions LLC · Oshkosh, WIS/N 258729N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373N361CAN361ca LLC · Wilmington, DEBuilt 2005 · S/N 258734N361LABest Friends Air LLC · Kerrville, TXBuilt 2001 · S/N 258562N375PFConch Air LLC · Green Bay, WIBuilt 2001 · S/N 258558N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565N383MVSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258403N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339N389SRIgnite Enterprises LLC · Cerritos, CABuilt 2002 · S/N 258575N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578N411SCRegistered aircraftBuilt 2004 · S/N 258653N412JADodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 258516N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657N423SGSworks Aviation LLC · Chicago, ILS/N 258472N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N43MMAircraft Holding Solutions LLC · Newark, DEBuilt 2001 · S/N 258543
Back to AD 2001-17-26 R1