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.

N2225ZLukezic Bret · Longmeadow, MABuilt 1979 · S/N 28-7911158N22262Oldenkamp David J · Payson, AZBuilt 1978 · S/N 32-7840191N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026N22266Oldenkamp David J · Payson, AZBuilt 1976 · S/N 28-7690208N2226DJenkins Danny W · Nebo, KYBuilt 1978 · S/N 28-7990166N2226NWingsleasing LLC · Wichita, KSBuilt 1979 · S/N 28-7990282N2226TRegistration Pending · Tucson, AZRegistration pending, pending cancellationBuilt 1971 · S/N 28R-7135171N2227CCain Jeffrey B · Godley, TXBuilt 1954 · S/N 18-4011N2227FBay Area Aviation LLC · Beach City, TXBuilt 2005 · S/N 18281681N2227HHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995173N2227JAldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7940010N2227RWilhite Randy J · Jackson, MIBuilt 1979 · S/N 28-7990309N2227XMoravec Jason A · Houston, TXBuilt 1979 · S/N 28-7990369N22281Boelke Christopher T · Starbuck, MNS/N 82174N2228THulsey Hunter · Madison, MSBuilt 2005 · S/N T18208480N2228ZThunderbird Aircraft Co · Bloomington, MNBuilt 1979 · S/N 28-7990408N22293Jacobson Duane A · Marco Island, FLBuilt 1978 · S/N 32R-7887253N22295Poole Frederick J · Meridian, MSBuilt 1978 · S/N 32R-7887254N2229JKaiser Hayward J · Los Angeles, CABuilt 1978 · S/N 32-7940011N2229QM21 Aircraft Leasing LLC · Morganton, NCBuilt 1977 · S/N 28-7790383N2229UCalifornia In Nice Inc DBA · San Jose, CABuilt 1979 · S/N 44-7995253N2229WCook Arlyn L · Alta Loma, CABuilt 1981 · S/N 28-8111084N2229YWehkamp Air LLC · Ingalls, KSBuilt 1979 · S/N 28-7990378N2229ZGeorge Walker Field Inc DBA · Bedminster, NJBuilt 1979 · S/N 28-7990409N222ARBrowne Michael · Big Lake, TXS/N 7010CN222AYCannoles Ronald · Las Vegas, NVBuilt 1979 · S/N 6005957961191N222BHLudwigson Joel R · Inver Grove, MNBuilt 1978 · S/N 24-0498N222BWAuer William E · East Liverpool, OHBuilt 2004 · S/N 074N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046N222ECInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 1-0041N222ESThakkar Ravi R · Charlotte, NCBuilt 2003 · S/N 80282N222FGoddspeed LLC · Encinitas, CABuilt 2000 · S/N T20608154N222GBJames David L DBA · Auburn, CAS/N 61P-0255-047N222GDSolverson Aircraft Management LLC · Waunakee, WIS/N 2185N222GESmith Daniel J · Mcmurray, PABuilt 1975 · S/N 32-7500020N222GFFischer Edward T · Appleton, WIBuilt 2002 · S/N 40.230N222GGLangley Richard A · Sheyenne, NDS/N 120-HN222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N222HMAmerican Saddlair LLC · Park City, UTBuilt 1994 · S/N 27-0183N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881N222HUPlane Nutz LLC · Sugar City, IDBuilt 2003 · S/N 2238N222HYWarner Robins Air Service Inc · Cochran, GABuilt 2006 · S/N 2335N222JAJeff Abrams LLC · Ocala, FLBuilt 2000 · S/N 3062N222JDAcro Aviation LLC · Littleton, COBuilt 1983 · S/N 5016N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222JLThomas Kent C · Muncie, INBuilt 1973 · S/N 32-7340135N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097N222KLLohmueller Kurt M · Powder Springs, GABuilt 2005 · S/N 21308N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270
Back to AD 2006-10-21