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.

N2281SHyce Richard A · Wasilla, AKBuilt 2015 · S/N TC0604103N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017N2284TKenley Clay · Crockett, TXBuilt 1977 · S/N R18200019N2284UAttitude Toys LLC · Wilmington, DES/N 454N2287AGiacopassi Dean · Newport News, VABuilt 2002 · S/N 40.226N2288FJ&Jn2288 LLC · Houston, TXBuilt 2018 · S/N 25428N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242N2288TRegistered aircraftBuilt 1966 · S/N 670204N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196N2289UEastern Stearman Inc Trustee · Leesburg, VABuilt 1966 · S/N 460N228AMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 28-7990544N228CABowles Thomas J · Prairie Village, KSBuilt 1981 · S/N R18201686N228CMKittleson Allen F · Granbury, TXBuilt 1973 · S/N 73-31058N228ERRoscioli Lamberto · Lighthouse Point, FLBuilt 1992 · S/N 10119N228FPRegistered aircraftS/N 24-2538N228GHopkins Boone K · Saint Simons Is, GAS/N 612N228GGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 28-7990387N228HPLance Reid Enterprises LLC · Turlock, CABuilt 1980 · S/N R18201643N228HSSweeney David H · Houston, TXBuilt 2003 · S/N T20608419N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711N228KHSkyceci LLC · Comelius, NCBuilt 2022 · S/N 2881521N228MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881985N228NCIal Corp · Lewes, DEBuilt 1969 · S/N 28R-35652N228QRMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881538N228SGCarver Gordon W · Wray, GABuilt 2015 · S/N 71237N228SHHayden Daniel · North Pole, AKBuilt 2006 · S/N 4014N228TWNorth Delta Aviation LLC · Blytheville, ARBuilt 2002 · S/N 172S9228N228UVMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881568N228WTHowland James · Grantsville, UTBuilt 1971 · S/N MC-90N22904Phoenix East Aviation LLC · Daytona Beach, FLS/N 172S9961N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959N2290NKalika Kelly · Collinsville, ILBuilt 1971 · S/N 28-7105136N2290TKnobloch Eric D · Green Cove Springs, FLFirst renewal noticeBuilt 1971 · S/N 28-7110022N2290UVan Surdam John R · Seneca, SCBuilt 1966 · S/N 461N2291CForty Four Fifteen LLC · Reno, NVBuilt 2005 · S/N 172S9962N2291UHines Scott C · Fort Worth, TXBuilt 1966 · S/N 462N2292MShymkewich Dale G · Arlington, VABuilt 1977 · S/N 28R-7837081N2293MFines Aviation #1 LLC · Fargo, NDBuilt 1977 · S/N 28R-7837082N2294QSouth Florida Helicopters Inc · Indiantown, FLS/N 28R-7737033N2294RSeeliger Jeremy E · Pasco, WABuilt 1978 · S/N R18200584N22952Winging It LLC · Lindon, UTBuilt 2007 · S/N T18208740N2296NMacsdea LLC · Van Nuys, CABuilt 2005 · S/N 172S9967N2296QKhawly Pablo Nickolai · Miramar, FLBuilt 1977 · S/N 32R-7780244N2296TRegistered aircraftS/N R18200021N2297MHunter Stokes & Associates LLC · Douglasville, GABuilt 1977 · S/N 32R-7880061N2297QFact Ware Inc · Newtown, PABuilt 1977 · S/N 32R-7780245N2297SRocketjet LLC · Incline Village, NVS/N R18201328N2298MLeft Seat Flyers LLC · Mount Pleasant, SCBuilt 1977 · S/N 32R-7880062N2298TT C Rocket LLC · Traverse City, MIBuilt 1977 · S/N R18200023
Back to AD 2006-10-21