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.

N2192PSandoval Tax Cpas Inc · Bakersfield, CABuilt 2005 · S/N 18281668N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043N2193GWestward Aviation · Boulder, COBuilt 2000 · S/N 27-0294N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266N2193WAzalea Utilities Inc · Summerville, SCBuilt 2005 · S/N 18281670N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203N2194LState Of Wisconsin · Madison, WIBuilt 2005 · S/N 18281672N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032N2195MKorba Sean · San Jose, CABuilt 1979 · S/N 28-7911090N2196LAerolisse LLC · Chouteau, OKBuilt 2005 · S/N T18208478N2196NThompson Kurt C · Rochester, MNBuilt 1979 · S/N 32-7940037N2196SHernandez Christopher A · Phoenix, AZBuilt 1968 · S/N 180753N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047N2196UZeiner Gary R · Greencastle, INBuilt 1964 · S/N 407N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048N2197XKelley Brian S · Vancouver, WAS/N 23293N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808N2198SPeavey Brian H · Houston, TXBuilt 1979 · S/N R18201314N21992Gilpin Sean F · Madison, ALBuilt 1978 · S/N 32R-7885265N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080N219CDCd Flyers LLC · Port Orange, FLBuilt 2001 · S/N 1124N219DL3 Wolfpack Sigma LLC · Overland Park, KSBuilt 1999 · S/N 4636209N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970N219DCMjz Ventures LLC · Dodge City, KSBuilt 2023 · S/N 11180026N219DGCtrl Electrical LLC · Lexington, NCBuilt 1999 · S/N 3246134N219DSJojo & Dino Ltd · Frederick, MDBuilt 2002 · S/N 40.219N219EAMusante Keith · Heber City, UTBuilt 2023 · S/N PX1520029N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458N219JRRoberts Pipeline Inc · Middletown, INBuilt 1973 · S/N 28-7410026N219LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2006 · S/N 11219N219MCHansen Todd · Friday Harbor, WABuilt 2004 · S/N 18281323N219PBChoptera LLC · Odem, TXBuilt 2019 · S/N 24960N219PDWolfair LLC · Lewes, DEBuilt 2005 · S/N 18281665N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695N219WYWolding Mylo · New Town, NDBuilt 2014 · S/N 3219N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122N21AGGronemeyer Jens · Deland, FLS/N 4636106N21AJAllcroft Roger A · Haydenville, MAS/N 754N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862
Back to AD 2006-10-21