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.

N212TVParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020070N212WARowland Roger A · Nampa, IDBuilt 2016 · S/N 001N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419N2130JEarly Bird Aviation LLC · Rillito, AZBuilt 1978 · S/N 28-7990214N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505N21313Foster Peter · University Park, TXBuilt 1978 · S/N 32R-7887200N21318Raw Racing Inc · Puyallup, WABuilt 1978 · S/N 44-7995046N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649N2131ESchuman William C II · Poplar Grove, ILBuilt 1997 · S/N 24-3401N2131JAllen Harvey · Elfrida, AZBuilt 1978 · S/N 28-7990215N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421N2132XChampionx LLC · Sugar Land, TXBuilt 1998 · S/N 27-0250N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467N2134SC Squared Inc · Stevensville, MDBuilt 1979 · S/N R18201307N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292N2136CPope Keith D · Mineral Wells, TXBuilt 1978 · S/N 28-7911022N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204N2137EMbg LLC · Mountain Home, IDBuilt 1997 · S/N 27-0230N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561
Back to AD 2006-10-21