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.

N125VSMcfarland Joel E · Pittsford, NYBuilt 1979 · S/N 28-7990399N125WB90er LLC · Wilmington, DEBuilt 2008 · S/N 505-2008N125WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12303N125WWRegistered aircraftBuilt 1998 · S/N 18280348N125WYNorthstar Aerospray Inc · Clara City, MNBuilt 2010 · S/N 3098N125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1963 · S/N 27-2366N1260JHillhouse Mark S · Angie, LABuilt 1975 · S/N 260N1260KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13053N1260XCross Paul D · Cowan, TNBuilt 1963 · S/N 133N1261Evy Holdings Inc · White Marsh, MDBuilt 2006 · S/N 172S10322N1261BClark Robert J · Brookshire, TXS/N 1261N1261TObrien Timothy D · Alplaus, NYBuilt 1972 · S/N 28-7205273N1262JMendez Leo Jr · Corpus Christi, TXS/N 262N1262XHawley Christopher M · Chandler, AZBuilt 1963 · S/N 135N12648Aircraft Trade Group LLC · Scandia, MNBuilt 1973 · S/N 17262143N1264XAnderson Kyle S · Portland, ORBuilt 1963 · S/N 137N1268JSiers Laurie A · Boardman, OHBuilt 1975 · S/N 268N1269CNovember 1269 Charlie LLC · East Montpelier, VTBuilt 1979 · S/N 17702693N1269TCheek Joey F · Red Bluff, CABuilt 2019 · S/N 001N126AAAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10076N126AVN106ka LLC · Manassas, VAS/N 172S10621N126BBG & M Aviation LLC · Kokomo, INBuilt 2001 · S/N 6046N126BSCape Island Aviation LLC · Millville, NJBuilt 2017 · S/N 172S12012N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257N126CMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 25094CN126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878N126JBElam Jon L · Trinity, ALBuilt 1990 · S/N 20026N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390N126RGPetersen Alfred Charles · Buffalo Grove, ILBuilt 1998 · S/N 26N126SCDriven Design Studio Pllc · Battle Creek, MIBuilt 1994 · S/N 270180N126SPPilling Stephen · Southport, NCBuilt 2005 · S/N 172S9796N126VAHuber Airpark Civic Club LLC · Seguin, TXBuilt 1996 · S/N 2581N126VUAmir Aviation LLC · Saint Petersburg, FLBuilt 1991 · S/N 10065N126WBFlying Blank LLC · La Crosse, WIBuilt 2005 · S/N 983-2005N1270JWendell Matthew D · Telford, PABuilt 1976 · S/N 507N1270KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13057N1270TTubman Wilbur C · Grand Rapids, MIBuilt 1972 · S/N 28-7205274N1270XFox Aviation Holdings LLC · Leesburg, INBuilt 1963 · S/N 143N1271JSimmons Marcus M · Glen Allen, VABuilt 1975 · S/N 271N1272TMyers Brent A · Palm Bay, FLBuilt 1972 · S/N 28R-7235252N1272XUrban Norman A · Ray, MIBuilt 1963 · S/N 145N1274JWorbey Philip Colin · Melbourne, FLBuilt 1975 · S/N 274N1275BWeisgram Ted · Corbett, ORBuilt 1995 · S/N 1287N1275JEllis Keith W · Springfield, MOBuilt 1975 · S/N 275N1275RHatter Dan D · Dumas, TXBuilt 1971 · S/N 32-53N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386
Back to AD 2006-10-21