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.

N16AUTulsa Air And Space Museum Inc · Tulsa, OKS/N 002N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115N16CBBoecher Carl A · Morrison, COBuilt 2018 · S/N 72745N16DLLincoln David · Henderson, NVBuilt 2022 · S/N 1310N16DPNdmi Inc · Greeneville, TNS/N 24-3024N16DVDecathlon LLC · Herndon, VABuilt 2021 · S/N 1193-2021N16ECSchnell Michael D · New Bremen, OHBuilt 1965 · S/N 28-2683N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189N16EMB J Air Ltd · Howard, OHBuilt 1976 · S/N 32R-7680228N16FWSwain Kenneth C · Harvard, ILS/N 28N16GAGuidance Helicopters Inc · Prescott, AZBuilt 2001 · S/N 3211N16GHGreysky LLC · Smyrna, TNBuilt 2026 · S/N 172S13519N16GLDuncan David · Colorado Springs, COS/N 0772N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675N16HMRfs Aviation LLC · Greer, SCBuilt 1977 · S/N 60-0483-156N16HWKelley John E · Bartlett, TNBuilt 2001 · S/N 1N16JCRl Equipment And Services LLC · Monument, COBuilt 1972 · S/N 3128N16JMAlexander Co · Colleyville, TXS/N 2016N16JSMace Terry G · Saint James, MNBuilt 1973 · S/N 28R-7335304N16KJJones Kevin M · Savannah, GABuilt 2009 · S/N 60472N16LCJohnson Neil D · Cincinnati, OHBuilt 1976 · S/N AA5B0385N16LDDodge Larry H · Hernando, FLBuilt 2006 · S/N 60350N16LKOber John A · Candor, NYBuilt 1966 · S/N 335N16LWWalters Linn R · Malabar, FLBuilt 1981 · S/N 1981N16MCHadachek Joshua L · Independence, ORBuilt 1977 · S/N AA5B0447N16MMGoff Bruce J · Williamstown, MABuilt 1981 · S/N 18268045N16PMRiordan James · Kanab, UTBuilt 2001 · S/N 2149N16PXSmith Howard Michael · Wynne, ARBuilt 1979 · S/N AA5B1079N16RAWesley Robert J · Chuckey, TNBuilt 1978 · S/N 944N16RCLake N16rc Partners LLC · Stamford, CTBuilt 1973 · S/N 576N16RHOppegard Nicholas D · Eagle River, AKS/N 104N16RJParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020193N16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVBuilt 1970 · S/N 31-639N16TTGeronimo Aerosport LLC · Dover, DEBuilt 2018 · S/N 3304N16UPSkinner Norman G · Osceola, IABuilt 1992 · S/N 22353N16UTWhite Alan J · Fishersville, VABuilt 1972 · S/N M-1396N16VLDaro Associates LLC · Mahwah, NJBuilt 2005 · S/N T18208392N16WHPrescott Scot · Alburgh, VTS/N WH-1N16WYAbbott Thomas B · Portland, MEBuilt 2010 · S/N 3100N16WZRud Gilman E · Coronado, CABuilt 2008 · S/N 3017N16XVOlson Mark D · Longmont, COBuilt 2010 · S/N 168N16XWJohnson Scott A · Laveen, AZBuilt 1991 · S/N 20037N16YPSebastian Aero Services Inc · Guaynabo, PRBuilt 1982 · S/N 31-8252008N16YSSealing Edward L · Port Orange, FLBuilt 2015 · S/N 41251N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496N1701CCleek Norris Eugene · Orland, CABuilt 1997 · S/N 237N1701EValiair Limited Co Trustee · Casper, WYBuilt 1978 · S/N 32R-7885002N1701ZInternational Air Services Inc Trustee · Carson City, NVBuilt 2001 · S/N 2307N1702HHesston College · Hesston, KSBuilt 1977 · S/N 28-7790336N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523
Back to AD 2006-10-21