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.

N210SKPray Aviation Inc · Augusta, KSBuilt 1960 · S/N TD-393N210STWar Eagle Enterprises LLC · Missoula, MTBuilt 2001 · S/N SH2363N210SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12431N210SXSims Stephen E · Locust Grove, GABuilt 1946 · S/N 394N210WDShillieto Gordon W · Burlington Flats, NYBuilt 1965 · S/N 936N2110TN2110t LLC · Columbus, OHBuilt 1971 · S/N 28R-7135056N2111ARoth David · Corrales, NMBuilt 1978 · S/N 32R-7987004N2111CKey City Fliers · Maquoketa, IABuilt 1978 · S/N 28-7911021N2111FDhs Operations LLC · Wilmington, DEBuilt 1978 · S/N 44-7995153N2111SSchwab Jollina Michelle · Arlington, TXBuilt 1970 · S/N 28R-31048N2111ZNunn Henry · Noble, OKBuilt 1973 · S/N 28-7305515N2112FBank Of Utah Trustee · Salt Lake City, UTS/N 44-7995154N2112HAir V Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7754121N2112KRocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1978 · S/N 28-7990234N2112NV & R Aviation LLC · Georgetown, TXBuilt 1979 · S/N 28-7990276N2112TMarsh James M · Polkton, NCBuilt 1971 · S/N 28R-7130002N2112ZWilson Mickey Ray · Skagway, AKBuilt 1979 · S/N 28-7990394N21131Emge Douglas W · Albertville, ALBuilt 1978 · S/N 28-7990035N2113GCarlson Lucas J · York, NEBuilt 1978 · S/N 28-7911071N2113KCalvin B Wiley · Summer Shade, KYS/N TD-283N2113T10 Mile Final 33 LLC · Charleston, SCBuilt 1971 · S/N 28R-7135058N2113WMarschke Corey A · Stevens Point, WIBuilt 1973 · S/N M-1441N21147Woolf Sarah Clark · Fresno, CABuilt 2004 · S/N T18208234N2114CLegacy By Design LLC · Durham, CAS/N 2114N2114DDixie Sky Flight LLC · Deridder, LABuilt 1978 · S/N 28-7911033N2114KRcs Services LLC · California, MDBuilt 1978 · S/N 28-7990235N2114QJet Air Inc · Iowa City, IABuilt 2004 · S/N 172S9616N2114RPower Michael L · Bend, ORBuilt 2004 · S/N T18208226N2114SCochise Community College · Douglas, AZBuilt 1979 · S/N R18201303N2114TPulka Michael R · Yardley, PABuilt 1971 · S/N 28R-7135060N2114WHippensteel Michael J · Newville, PABuilt 1973 · S/N M1449N2114ZEagle & Associates LLC · Lake City, FLBuilt 1982 · S/N 75N2115BMisner Gear K · Phoenix, AZBuilt 1979 · S/N 32R-7987026N2115KLiprie Randal C · Lake Charles, LABuilt 2004 · S/N 18281322N2115MRedman Company LLC · Troy, MIBuilt 1972 · S/N 177-01703N2115UDengler Steven G · Lopez Island, WAS/N 163N2116UBreaux Family Investments LLC · Alexander City, ALS/N 28-7990329N2116ZBush Stanley D · Anthony, NMBuilt 1979 · S/N 28-7911150N21177Valiair Lc Trustee · Casper, WYBuilt 1970 · S/N 177-01578N2117HEarl Nathan E · Noblesville, INBuilt 1978 · S/N 32R-7985045N2117TCruce Aviation LLC · Marquette Heights, ILBuilt 1971 · S/N 28R-7135062N2117USouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 28R-7918066N21183Bkr LLC · Jacksonville, FLBuilt 1978 · S/N 32-7840184N2118ASouth Dakota Highway Patrol · Pierre, SDBuilt 2004 · S/N T20608451N2118JLamb Chops Inc · Bakersfield, CABuilt 2004 · S/N T18208238N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676N2118NBillberry Daniel · Chula Vista, CABuilt 1979 · S/N 28R-7918037N2118WWegner John B · Preston, MDBuilt 1973 · S/N M-1491N2118YS&G Enterprise Inc · Owensville, INBuilt 1962 · S/N 17249618N21198Jackie Hood Farms LLC · Moulton, ALBuilt 2005 · S/N 18281647
Back to AD 2006-10-21