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.

N128ACCga Holdings LLC · Kalispell, MTBuilt 1974 · S/N 61-0170-084N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218N128CPMaule Flight Inc · Moultrie, GAS/N 18066CN128DHMorris Thomas E · Orlando, FLBuilt 1998 · S/N 18040CN128ESturges John A · Hayden, IDBuilt 1966 · S/N 1190N128EHJen Air LLC · Greenwood, MSBuilt 2003 · S/N 1305N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806N128KMScott Mark A · Newman Lake, WABuilt 2002 · S/N SWINKELS 801N128KRRogue Texan Outfitters LLC · Skidmore, TXBuilt 1994 · S/N 0047N128LFLewis Michael D · Jenks, OKBuilt 2004 · S/N 81507N128MBParker Rodger D · Sedona, AZBuilt 1981 · S/N 62P08768165013N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220N128PBHayes Thomas G · Kerrville, TXBuilt 1966 · S/N 1283N128PHWayne Terry · Belews Creek, NCBuilt 2023 · S/N 1218N128PSShoen Paul F · Gardnerville, NVBuilt 1964 · S/N 3066N128SAFly-Right Aviation LLC · Anderson, SCS/N 355N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457N128TBlakesmith Don G · London Mills, ILBuilt 1990 · S/N 770N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017N128VUTiger 2 Flying Club LLC · Geneseo, ILBuilt 1991 · S/N 10067N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579N128YGorge Flight LLC · White Salmon, WABuilt 2016 · S/N 1128N1290JKrister Robert A · Kent, OHBuilt 1975 · S/N 290N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696N1292JSoutheast Michigan Aircraft Sales Inc · Blissfield, MIBuilt 1975 · S/N 292N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165N1293TN1293t LLC · Wilmington, DES/N 34-7250283N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699N1296XFox Judy · Ridgefield, WAS/N 169N1297JLemrich Aero Inc · Dallas, TXS/N 297N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112N1297XScott Benjamin D · Grove City, OHS/N 170N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394N1299AHunsicker Greg A · Berryton, KSBuilt 2000 · S/N 80252N1299XMunoz David · Corona, CAS/N 2680N1299ZWojdac David E · Mosinee, WIS/N TD-467N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574N129AXBradley William R · Colorado Springs, COBuilt 2005 · S/N 60326N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CCN129CPUpright Aviation LLC · Helena, MTBuilt 2001 · S/N 18067CN129GCBlue Air Training Corp · Las Vegas, NVBuilt 1980 · S/N 55
Back to AD 2006-10-21