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.

N166GAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 40.369N166JKKoon James A · Fortson, GABuilt 2008 · S/N 25697N166JPBaby Bird Aviation LLC · Sarasota, FLBuilt 2005 · S/N 40.502N166JRLinebaugh Jeffrey A · Port Orange, FLBuilt 2013 · S/N 042N166LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881373N166LMFlight Rt LLC · Thonotosassa, FLS/N 4063CN166NGVaught Timothy A · Mauldin, SCBuilt 1975 · S/N 32-7500016N166PTTurnbull Clayton · Kamuela, HIBuilt 2000 · S/N 200N166RVYoungdahl Thomas P · Mendota Heights, MNS/N 1944N166RWGrasshopper Aviation LLC · Betsy Layne, KYBuilt 1984 · S/N 8041-CN166TCCaple William Henry Jr · Chandler, AZS/N 25023N1671BEwing Willard Paul · Becker, MNS/N 1N1671CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11759N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500N167CSBalister Adrian G · Colorado Springs, COS/N 23197N167CWNorinsky David · Petaluma, CABuilt 2002 · S/N 1001N167LDRegistered aircraftS/N 670105N167LPSymanowski Kevin L · Reeder, NDBuilt 2001 · S/N 18281067N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N167SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 30064N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513N1683CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11764N1685Lane Aviation LLC · Tijeras, NMBuilt 2008 · S/N 030-53/54-704N1687CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11731N1688CAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10612N1688LHeavy Metal Air LLC · Farmingdale, NYS/N 172S10613N16894Saz Dynamics LLC · Daly City, CABuilt 2007 · S/N 172S10615N16895Luxair LLC · College Station, TXBuilt 2007 · S/N 172S10618N168AAWest Elk Capital LLC · Niwot, COBuilt 2007 · S/N 2392N168ALWittman Matthew · New York, NYBuilt 2000 · S/N 60168N168AVAce Helicopters LLC · Colfax, WIBuilt 2008 · S/N 1968N168BCWildlife Air LLC · Dubois, WYBuilt 2006 · S/N 482-2006N168BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881768N168CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13068N168CBLogan Air Services LLC · Logan, UTBuilt 2002 · S/N 172S9119
Back to AD 2006-10-21