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.

N1214Henderson Joseph · Camargo, ILBuilt 1976 · S/N JWM-2N1214TPost 8 Flight Opps Inc · Topeka, KSBuilt 1972 · S/N 28-7205268N1214XCouch Troy L · Westcliffe, COBuilt 1963 · S/N 2617N1215JRinggold Rolf E · Circle Pines, MNBuilt 1974 · S/N 215N1215LMagrini Shawn P · Salem, OHBuilt 1996 · S/N 1552N1215XCella Joseph · Sewell, NJBuilt 1963 · S/N 2618N1216LLynch Steven J · Harrisville, RIBuilt 1975 · S/N 719N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238N1217EJohnston Jason · Chugiak, AKS/N 255-77N1217PHarrison Jeffrey · Benton, ARS/N 61P-0395-135N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N1218JWeeks Wesley J · Iowa Park, TXS/N 218N1218SSkyvibe Leasing LLC · Aurora, ORBuilt 2012 · S/N 172S11161N1218WOndrick Aviation LLC · Chicopee, MABuilt 2003 · S/N 3255006N1218XSmith II Richard D · Luthersville, GABuilt 1963 · S/N 2621N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265N121AWhidby Richard L · Aynor, SCBuilt 1992 · S/N 2045N121AHSoul Shine LLC · Nashville, TNBuilt 2004 · S/N 10548N121ARGold Mountain LLC · Kalispell, MTBuilt 1979 · S/N 53N121AVPreece William F · Cheshire, CTBuilt 1984 · S/N 28-8490078N121CJCharlie Juliet Aerospace LLC · Naugatuck, CTBuilt 2005 · S/N 40.466N121CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13480N121CWAerostar Training Services LLC · Kissimmee, FLBuilt 2001 · S/N 172S8975N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024N121DSGarvison Paul L · Hillsville, VABuilt 1995 · S/N 22373N121DWFlight World Inc · San Juan, PRBuilt 1972 · S/N 312N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173N121GHSunset Aviation LLC · Huntington, INBuilt 1977 · S/N 32R-7780262N121GKBook Thomas D · Loveland, COBuilt 2003 · S/N 2767N121GRSimmons Scott J · Palm Springs, CABuilt 1978 · S/N 2159N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209N121HSCharles Dan H · Des Allemands, LAS/N 121N121JCNewsom William A · Cheraw, SCBuilt 2000 · S/N F0010N121JLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N ODOM 0001N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529N121LTDream 10 LLC · Dunnellon, FLBuilt 2024 · S/N 42367N121PRPaulich John III · Naples, FLBuilt 2005 · S/N 71295N121RFRafamedia LLC · Stamford, CTBuilt 1976 · S/N 13048N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25N121SXRegistered aircraftBuilt 2018 · S/N 14147N121TDelmarva Flight Leasing Inc · East Moriches, NYBuilt 1992 · S/N 270124N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105
Back to AD 2006-10-21