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.

N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117N2091ERebayr Inc · Mooresville, INBuilt 2002 · S/N S1837N2091PStahler Corporation Ltd · Bexley, OHBuilt 1979 · S/N 32-7940041N2091WDestefano Patrick · Adamsville, TNS/N 28R-7918076N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182N2092CElam Nathan A · Hereford, TXBuilt 1978 · S/N 28-7911020N2092DSelchow Stuart · Plato, MNBuilt 1978 · S/N 28-7911032N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228N2093SSkyline Aviation Inc · San Angelo, TXS/N S1910N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038N2093XWord Kyle Remington · Albuquerque, NMBuilt 1979 · S/N 28-7911140N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116N2094PCampbell John A · Brentwood, TNBuilt 1979 · S/N 32R-7985077N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571N2095JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608554N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180N2095SMrk Aviation LLC · Delray Beach, FLBuilt 2004 · S/N T20608442N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077N2096ARegistration Pending · Malden, MORegistration pendingBuilt 1978 · S/N 32R-7985001N2096BN2096b LLC · Buffalo, NYBuilt 1978 · S/N 28-7911008N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585N2098CLynch Stephen J · Stamford, CTBuilt 2004 · S/N T18208228N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030N2099CFrazier Jon A · Vista, CAS/N TD-276N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438N2099YThompson And Harvey Holdings LLC · Orcutt, CABuilt 2004 · S/N T20608444N209ARGeery James J · North Fort Myers, FLBuilt 2007 · S/N 71261N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554N209BZHipple Patrick · Brecksville, OHS/N SS890830N209DSMassman Enterprises LLC · River Hills, WIBuilt 2004 · S/N 40.409N209JGPotter Gary W · Abilene, TXBuilt 1987 · S/N 1N209JMNewell George C · Lakeview, MIBuilt 2015 · S/N 40981N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008
Back to AD 2006-10-21