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.

N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042N153AAHorn Jack E · Erie, COBuilt 2007 · S/N 2386N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93N153AMMedford Daniel E · Lakeville, MNS/N 17702222N153BAGeorge Tim D · Cleburne, TXBuilt 2010 · S/N 880211N153BDM & M Farms · Fowler, KSS/N 80939N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415N153EJQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N 31P-8414011N153GReese Paul D · Elkview, WVBuilt 2007 · S/N 1039-2007N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602N153GMFly High Aviation LLC · Melrose Park, ILBuilt 1992 · S/N 5266N153JPPew John R · Casa Grande, AZBuilt 2007 · S/N 053N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019N153MBaker Thomas J · Oxford, MDBuilt 2011 · S/N 82655N153MCHollingshead Keith · Clarksboro, NJBuilt 2004 · S/N 60128N153MKThomas Paul · Falls Church, VABuilt 1984 · S/N 32-8406009N153PCRegistered aircraftBuilt 2009 · S/N 172S10956N153SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4147N153TAAmerican Eagle 1 LLC · Kimberling City, MOBuilt 2001 · S/N 18281053N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329N153WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 0152N154Nystrom Timothy L · Foreston, MNBuilt 1974 · S/N 28-7405097N15405Kurin Kerry · Tulsa, OKBuilt 1972 · S/N 28-7305070N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040N15410Simpson Randal L · Missouri City, TXBuilt 1972 · S/N 28-7310043N15417Coburn Kyler J · Mountain Home, IDBuilt 1972 · S/N 28-7305073N1541CSwan Russell · Glenside, PABuilt 1963 · S/N 28-10042N1541RHall Daniel · Haskell, OKBuilt 1975 · S/N AA5B-0041N1541XSheffer Marshall A · Herrin, ILBuilt 1975 · S/N 32-7540171N15426Piper Pilots LLC · Wilsonville, ORBuilt 1972 · S/N 28-7305075N1542RHoose Michael J · Cortland, NYS/N AA5B-0042N15438Max Motors LLC · Encino, CABuilt 1972 · S/N 28-7305077N1543RHettlinger Eric R · Terre Haute, INBuilt 1975 · S/N AA5B-0043N15442Buchanan Ethan D · Au Gres, MIBuilt 1972 · S/N 28-7310046N1544CElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8365N1545RSanders Harrison S · West Columbia, TXBuilt 1975 · S/N AA5B-0045N15471Sport Air Inc · York, PABuilt 1972 · S/N 28-7305080N15472Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 28-7305081
Back to AD 2006-10-21