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.

N207PDFirefly Leasing Inc · South Carver, MABuilt 2003 · S/N 1330N207PKDufault Daniel R · Lincolnville, MEBuilt 2019 · S/N 3320N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485N207TJBoos Timothy J · Fort Atkinson, WIBuilt 2007 · S/N 71909N207VRB&C Properties LLC · Bristol, WIS/N 32-58N207XBane Russell · Palm Beach Gardens, FLBuilt 2005 · S/N 1207N2080QHyperion Enterprises LLC · Warrenton, VABuilt 2005 · S/N T18208450N20816Dawson Matthew · Springfield, MOBuilt 1980 · S/N 32R-8029001N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179N20818N20818 LLC · Wilmington, DES/N 172S12579N2081AKing David M · Ormond Beach, FLBuilt 1978 · S/N 32R-7885283N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025N20826Lc Aviation LLC · Mocksville, NCBuilt 2004 · S/N 0182N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N20848Lown Jeffrey B II · Shrewsbury, NJBuilt 1979 · S/N 28-7911080N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081N2084DWaves4days LLC · El Segundo, CABuilt 2004 · S/N SRG061N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028N2085POphelia Aviation LLC · Paradise Valley, AZBuilt 1979 · S/N 28-7911102N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458N2086TEllis Amy E · Santa Rosa, CABuilt 1970 · S/N 28R-7135030N2086WSanders Flight Training Center LLC · Jasper, ALS/N TD-644N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027N2087ASmith Morris A · Odessa, TXFirst renewal noticeBuilt 1978 · S/N 32R-7987001N2087DIsaac Mohsen · Venetia, PABuilt 1978 · S/N 28-7911031N2087PGold Mountain LLC · Kalispell, MTBuilt 1977 · S/N 36N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581N20887N20887 LLC · Augusta, GABuilt 2005 · S/N T18208452N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176N2089RSchwettmann Dennis E · Nampa, IDBuilt 1993 · S/N 17N2089TBeusekom Jeremy Van · Eden Prairie, MNBuilt 1970 · S/N 28R-7135033N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502N208CWWawock Richard L · Murphy, IDBuilt 2014 · S/N 72141N208DCRay David L · Yelm, WABuilt 2001 · S/N 81103N208EFAero208 LLC · Boise, IDBuilt 1966 · S/N 28-3632N208ETSaunders Warren C IV · Oklahoma City, OKS/N 82721N208EZFesta Nerio F · Penngrove, CAS/N 2-24N208FT423 East Young LLC · Warrensburg, MOBuilt 2005 · S/N T20608573N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073N208PFChristensen Todd S · Ririe, IDBuilt 2014 · S/N 6793N208PHSullivan Farms LLC · Alachua, FLBuilt 2008 · S/N 3010N208THN208th LLC · Villa Rica, GAS/N 3246122N2090American Valet Air Inc · Wilmington, DEBuilt 1981 · S/N 27-8154010
Back to AD 2006-10-21