AD 2006-10-21

Registered aircraft · 44,908

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

N205SGWilliams Christopher · Wallingford, KYBuilt 2005 · S/N 3255041N205SHBuzzard Aviation Inc · Freer, TXS/N 0773N205TGLe Garrec Jean-Dominique M · Pittsburgh, PABuilt 1987 · S/N 24-3041N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282N205ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881606N2060UJade Air LLC · Lomita, CABuilt 2005 · S/N 172S9952N20617Mtnairpower LLC · Santa Barbara, CABuilt 2017 · S/N T20609522N2061BM R O Drug Test Results LLC · Wintersville, OHBuilt 2003 · S/N 20608200N2062CBc Realty Group LLC · Lake Dallas, TXBuilt 1959 · S/N TD-262N2062HRoonie Inc · Wilmington, DEBuilt 2002 · S/N 0133N2062LJohnson Robert A · Crawfordville, FLBuilt 1976 · S/N M-1863N2062MJadma LLC · Helena, MTBuilt 1977 · S/N 32R-7880051N2062NRegistered aircraftBuilt 2002 · S/N S1830N2062RMiller Mark T · Sugarcreek, OHBuilt 1969 · S/N 28-5447N2063PRegistered aircraftBuilt 2005 · S/N 18281644N2064TClarke Bruce B · Port Angeles, WABuilt 1970 · S/N 28R-7135001N2065LAirspeed Jet Services LLC · Kirkland, WABuilt 1959 · S/N TD-209N2065POakland Helidrone Industrial LLC · Auburn Hills, MIBuilt 2002 · S/N 0140N2067LShort Final Aviation LLC · Siloam Springs, ARBuilt 1976 · S/N M-1866N2067MDurant William C · Skyland, NCBuilt 2003 · S/N 60583N2068SN2068s LLC · Solana Beach, CAFirst renewal noticeBuilt 1979 · S/N R18201295N20691High Life Helicopters LLC · Kalispell, MTBuilt 2003 · S/N S1846N206AGDesevarg Inc · Appleton, WIBuilt 2020 · S/N T20609618N206AMLiu Ke · Millburn, NJBuilt 2003 · S/N T20608436N206ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496036N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227N206CVC & C Transportation Inc · Benton, LABuilt 2000 · S/N T20608164N206DWAlaskan Start Aviation LLC · Midland, TXBuilt 1999 · S/N T20608145N206EAAbrams Edward L · Roxbury, CTBuilt 2000 · S/N T20608186N206EEHastings Ranch Vineyard · Paso Robles, CABuilt 2005 · S/N T20608505N206GCCook Tyler · Seldovia, AKBuilt 2002 · S/N 20608001N206HTPepke Mark E · Memphis, TNS/N 401N206JAFabick John D · Saint Louis, MOBuilt 1999 · S/N 20608014N206KMHoskins Marc R · Kennett, MOBuilt 2001 · S/N 20608153N206KTStephens Dennis II · Lake Jackson, TXBuilt 2003 · S/N 00127N206LWestern Air Pilots LLC · Mountain Home, ARBuilt 2004 · S/N T20608498N206LMQualitair LLC · MichelstadtBuilt 1977 · S/N U20603759N206MKFuhrig Austin T · Anchorage, AKBuilt 2007 · S/N MK2N206MZKtbr Holdings LLC · Statesboro, GABuilt 2005 · S/N T20608551N206PMTunnel Aviation LLC · Tunnel Hill, GABuilt 2002 · S/N T20608376N206RPFinley Aviation LLC · Fort Worth, TXBuilt 2005 · S/N T20608516N206SJUrbana Aviation LLC · Woodstock, OHBuilt 1998 · S/N T20608007N206TJSky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11097N206VSBos Ranch LLC · Reno, NVBuilt 1999 · S/N T20608030N206WKKaw Corp · Mcallen, TXBuilt 2001 · S/N T20608318N206WYAerotrust Services Corp Owner Trustee · Wilmington, DEBuilt 2000 · S/N T20608187N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226N2070RRosies Procurment LLC · Midlothian, TXBuilt 1997 · S/N 27-0227
Back to AD 2006-10-21