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.

N1410Swe3 LLC · Seattle, WABuilt 1982 · S/N 7-0489N1410EGulf Atlantic Airways Inc · Gainesville, FLBuilt 2008 · S/N 172S10667N1411Grubb Logan · Faulkton, SDBuilt 1963 · S/N 1111N1411JSimmons John W · Ocala, FLBuilt 1975 · S/N 411N1411TCable Marsha A · Toronto, OHBuilt 1972 · S/N 28R-7235282N1411ZGrindeland Edson M · Hatton, NDBuilt 2014 · S/N 81680N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701N14135Olympiakh LLC · Louisville, KYBuilt 1971 · S/N 27-4702N14138Island Bound LLC · Dunedin, FLS/N 27-4704N14149Ninja Turtle LLC · Orlando, FLBuilt 1971 · S/N 27-4712N1414TThomas Evan C · Lancaster, CABuilt 1985 · S/N 206N1415JSale Reported · Irving, TXSale reportedBuilt 1975 · S/N 415N1415XLaramee Michael E · Goldsboro, NCBuilt 1999 · S/N 8119N14175Box Aviation Inc · Montgomery, ALBuilt 1971 · S/N 27-4739N14183Osborne Donald R · Fairbury, NEBuilt 1971 · S/N 27-4747N1418ABay Ronald · Hunt Valley, MDBuilt 2008 · S/N 172S10670N1418JAaa Training LLC · Kalispell, MTBuilt 1975 · S/N 418N1418RHall James E · Shalimar, FLBuilt 1975 · S/N AA1B-0518N1418TZucchi Steven · Ephrata, PABuilt 1972 · S/N 28-7205295N1418XHaskin Kent B · Claverack, NYBuilt 1975 · S/N 28R-7535276N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724N1419DAir America Flight Center LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10671N1419FAir Callahan LLC · Bonita Springs, FLBuilt 2008 · S/N 172S10672N1419TBrolan Aviation LLC · Kansas City, MOS/N 28R-7235283N1419XWhitman Aviation LLC · Morganville, NJS/N 32-7540160N141AAHeavy Metal Air LLC · Farmingdale, NYBuilt 2007 · S/N 172S10630N141AFSmith Michael J · Brandon, MSBuilt 1995 · S/N 0014N141ANWells Ryan · Holdrege, NES/N 32-7940062N141AREpp Robert Jackson · New Kent, VAS/N 8060CN141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022N141CDSky Helicopters Inc · Desoto, TXBuilt 2023 · S/N 30091N141CHRegistered aircraftBuilt 1979 · S/N 324-79N141CLFulbright Charles M · Toccoa, GABuilt 1967 · S/N TD-692N141CMMoran Christopher C · Colleyville, TXBuilt 2022 · S/N 42310N141DDCox Aviation Services LLC · Acworth, GABuilt 1999 · S/N 3246132N141FAnderson Jon J · Hill City, SDBuilt 1998 · S/N 1400N141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2019 · S/N 2881158N141FQCross Daniel · Windham, NHS/N 28-8290176N141FWSchultz Frank R · Lafayette, COBuilt 2011 · S/N 22898N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117N141NCheney John A · North Baltimore, OHBuilt 1976 · S/N 902N141PNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-237N141RBClevenger Glen D · Cottage Grove, ORFirst renewal noticeBuilt 1997 · S/N 22285N141RSFrederick Investment Corp · Raleigh, NCS/N 26006CN141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244N141SEHydro Flyers LLC · Woodside, CABuilt 2006 · S/N 1024-2006N1420N5504r LLC · Jefferson City, MOBuilt 1993 · S/N 10172N14202Hodge Uriel · St Thomas, VIS/N 27-4762N14207Belk William E · Labelle, FLBuilt 1971 · S/N 27-4767
Back to AD 2006-10-21