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.

N2040LLake Fun Llp · Terre Haute, INBuilt 1968 · S/N 373N20410Widjokongko Antonius · League City, TXBuilt 1977 · S/N 17702670N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520N20416Carl L Mccallister Inc · Wilmington, DEBuilt 2005 · S/N 18281642N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522N2041LSlik Air LLC · Topeka, KSBuilt 1976 · S/N M-1849N2041RBlair Darrell E · Trinity, NCBuilt 1969 · S/N 28-5440N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219N2043Precision Aero LLC · Wilmington, DEBuilt 1998 · S/N 28008CN2043CLouisiana Community And Technical College System · New Iberia, LABuilt 2008 · S/N 0329N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441N20448Delta Echo Whiskey LLC · Apopka, FLBuilt 1982 · S/N R18201923N20449J2 Aero LLC · Ringgold, GABuilt 2008 · S/N 0330N2044DMyalik Gennady K · Campobello, SCS/N 0116N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440N2044YPsalm 19:1 Aviation LLC · Annapolis, MDBuilt 2005 · S/N 18281643N2046CTexflight LLC · Beaumont, TXBuilt 2001 · S/N 0127N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092N2046LRegistration Pending · Bonham, TXRegistration pendingBuilt 1976 · S/N MC-433N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443N2047CPropp & Wings LLC · Missoula, MTBuilt 2005 · S/N T18208445N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324N20489Lone Oak Properties LLC · Flagstaff, AZBuilt 2005 · S/N T18208446N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857N20491Ross Johnathan M · Eagle River, AKBuilt 2002 · S/N 002N20495Pitts Dan O · Soldotna, AKBuilt 1988 · S/N 1045N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234N2049PVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208448N2049RHook Sean · Garden Ridge, TXBuilt 1969 · S/N 28-5445N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119N204GACoen Brady · Wiley, COBuilt 1997 · S/N 200-9724FN204GLChrist Robert D · Mandeville, LABuilt 2014 · S/N 1204N204GSBooth William F Sr · Fredericksburg, VABuilt 2008 · S/N 40274N204HWNordman Marvin J · Great Bend, KSBuilt 2004 · S/N 25151N204LCUtah State University · Logan, UTBuilt 2004 · S/N 10248N204MATsiu LLC · Wilmington, DEBuilt 2000 · S/N 2075N204MEArgo Aviation Inc Trustee · Wilmington, DEBuilt 1989 · S/N 909N204MMAvest Ltd · Hilltop Lakes, TXS/N 24-0718N204PCHestertown Aviation LLC · Monroe, GABuilt 1973 · S/N 32-7440036N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844N204RKHermann Ron A · Sarasota, FLBuilt 1985 · S/N 28-8611003N204RVCollette John D · Las Vegas, NVBuilt 1999 · S/N 832N204SCGyure Ronald J · Fort Worth, TXBuilt 1965 · S/N 27-2796N204SDOstern Mark Lynn · Rapid City, SDS/N 958-2004N204SGSquillace Daniel J · Cary, NCBuilt 2005 · S/N 40.482N204SJStuart M Davis Inc · Rice, WABuilt 1972 · S/N 32-7240097N204SLBethesda Family Lp · Auburn, CAS/N 0023
Back to AD 2006-10-21