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.

N177RCChase Bruce R · New Albany, PABuilt 1973 · S/N 17701895N177RDMoulton Diana L · Pine Mountain Club, CAS/N 17701565N177RWDg Aviation LLC · Avon, INBuilt 1994 · S/N W-2N177SHAdams Richard D · Kalamazoo, MIBuilt 1975 · S/N 17702294N177SMFree State Flying Club Inc · College Park, MDBuilt 1974 · S/N 17702124N177SRTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2001 · S/N 3275N177SVDlg Aviation LLC · Lena, WIBuilt 1970 · S/N 17701494N177TJCobb Joseph Jr · Medina, OHBuilt 1976 · S/N 17702593N177TSAero Cardinalis Inc · Midlothian, TXBuilt 1975 · S/N 17702295N177VTSeelig Richard W · Amherst, MABuilt 1973 · S/N 17701997N177WCDittmer William R · Wheatland, NDS/N 28-7890535N177WMFarley Glen · Marysville, OHBuilt 1973 · S/N 17702011N177XCColeman Timothy R · Morgantown, KYBuilt 1970 · S/N 17701538N177XSWilson Kent M · Roanoke, VABuilt 1971 · S/N 17701669N1780Nelson Kevin T · Corvallis, ORBuilt 2021 · S/N 60352N1781RDale Mar Enterprises Inc · Granton, WIBuilt 1978 · S/N R18200557N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113N1786RWhalen Dann Trustee · San Diego, CABuilt 1978 · S/N R18200559N1787DKissel Patrick J · Anchorage, AKBuilt 1951 · S/N 20230N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177N178ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010055N178BCAllen Lisa M · Melba, IDBuilt 2005 · S/N 474-2005N178BDMiltimore Jeffry D · Newark, OHBuilt 1975 · S/N BH120/215N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039N178DKSchenck James R Trustee · Mclean, VABuilt 2018 · S/N 1178-2018N178DMMukherjee Sanjoy · Flemington, NJBuilt 2005 · S/N 777-320-619FBN178DRH&H Trucking Inc · Clarkdale, AZBuilt 1970 · S/N 17701575N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028N178MAMayes Richard A · Bend, ORBuilt 2013 · S/N 3170N178MCWillett Cattle Co · Sanford, COBuilt 1973 · S/N 327340178N178TTLockwood Kurt G · Fairbanks, AKBuilt 1978 · S/N 278-78N17915US Aviation Training Solutions (Usats) · Titusville, FLBuilt 2006 · S/N 0235N179AMNorth American Flight Services Inc · Ballston Spa, NYBuilt 2005 · S/N 2317N179BCDenmark Ag · Winters, CAS/N 458-2004N179BWAshmore Lance E · Rogers, ARBuilt 2008 · S/N 3029N179DHicks Jonathan · Edgewood, TXBuilt 2013 · S/N 3175N179ECKibler Inc · Wilmington, DEBuilt 1972 · S/N 31-839N179GCWolfpacc Inc · Ponte Vedra, FLBuilt 2005 · S/N 062N179GTNeedham Charles Scott · Washington, UTBuilt 1979 · S/N AA5B-0962N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481N179MAAir-Knechtions LLC · Batavia, ILBuilt 2003 · S/N 260012N179MEFlight Rt LLC · Thonotosassa, FLBuilt 2000 · S/N T20608184N179NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010009N179PCMsb Aero LLC · Middletown, DES/N 1029-2006N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074N17ACPressley Brent DBA · Morristown, TNBuilt 1967 · S/N 670329
Back to AD 2006-10-21