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.

N1420JMaupertuis Frederick E · Henderson, NVBuilt 1975 · S/N 420N1421JBrindle Richard L · Pleasant Hall, PABuilt 1975 · S/N 421N1421TBurr Charles R Jr · Palm Bay, FLBuilt 1972 · S/N 34-7250314N1421WSurgent Richard L · Wall Township, NJBuilt 2002 · S/N 95-0308N14224Townley William V · Weirsdale, FLBuilt 1972 · S/N 27-4783N14229Holt Bryan J · Flowery Branch, GABuilt 1972 · S/N 27-4794N1422CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12894N1422JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13175N1423JSandyland LLC · Madison, FLBuilt 1975 · S/N 423N14243Blitz Daniel R · Corsicana, TXBuilt 1972 · S/N 27-4795N14244Pacific Fleet Aviation LLC · Rochester, NYBuilt 1972 · S/N 27-4796N1424CGlendoe Inc Trustee · Wilmington, DEBuilt 2005 · S/N 18281610N1424JDuwelius Sue DBA · Hermiston, ORBuilt 1975 · S/N 424N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043N1424NEbonaster Enterprises LLC · Slidell, LABuilt 1966 · S/N 24-4383N14252Caja Aviation LLC · Cheyenne, WYBuilt 1972 · S/N 27-4813N1425KTopaircraft Classic Wings Holding LLC · Eureka, MOS/N 10153N1425TSkydance Aviation LLC · Norfolk, VABuilt 1972 · S/N 28R-7235286N14268Kilgore Garrett M · Whitwell, TNS/N 27-4828N1426JKvistad Charles O · Granite Falls, MNBuilt 1975 · S/N 426N1426SBoundless LLC · Dakota Dunes, SDBuilt 1971 · S/N 27-4680N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038N14281Technical Education Services Inc T/A · Virginia Beach, VABuilt 1972 · S/N 27-4843N1428JLeedham James E DBA · Mazeppa, MNBuilt 1966 · S/N 28-3539N14297Barrett Eric W · Cherry Hill, NJBuilt 2005 · S/N 18281715N1429XRegistered aircraftBuilt 1975 · S/N 28R-7535278N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92N142BLipinski Glen E · Chandler, AZBuilt 1992 · S/N 10134N142BESugar Pop Group LLC · Saco, MEBuilt 2001 · S/N 14103CN142BSChristian Tax Advisors LLC · Houston, TXBuilt 2005 · S/N 172S9881N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161N142CFArq Aviation LLC · Wilmington, NCBuilt 2020 · S/N 172S12437N142DGYuba Sutter Aviation · Olivehurst, CABuilt 1981 · S/N BB-01N142DLRoss Branta Enterprises · Boise, IDBuilt 2004 · S/N 18281470N142EJAskwig Michael C · Lincoln, MIS/N 372N142FAKrause Frank · Sarasota, FLBuilt 2010 · S/N 144N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177N142GVan Strien Greg · Lowell, MIBuilt 2019 · S/N 22278N142JGRegistered aircraftBuilt 1999 · S/N 3921N142JHParoaria LLC · Williamsville, NYBuilt 2008 · S/N 40454N142JPEvans Jesse G · Powder Springs, GABuilt 2000 · S/N 23636N142KWPhillips John C · Moneta, VABuilt 2019 · S/N 40610N142LESky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 01N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177N142LLHr II LLC · Prescott, AZBuilt 2001 · S/N 167N142LMLamm Aviation Lc · Lees Summit, MOBuilt 2015 · S/N 41420N142MLGuinn Gary L · Tulsa, OKBuilt 2004 · S/N 3RX034N142PSSidney Aviation LLC · Sidney, NEBuilt 1999 · S/N 6022N142UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11490N142VABuffalo Sales And Leasing LLC · Missoula, MTBuilt 2005 · S/N 3771
Back to AD 2006-10-21