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.

N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785N21022Ameriflyers Of Texas Inc · Addison, TXBuilt 2004 · S/N 172S9660N21027Noomen Excavating LLC · Currie, MNBuilt 1978 · S/N 32R-7887187N2102BGillen Diesel Aviation LLC · Dania Beach, FLBuilt 1978 · S/N 32R-7985011N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461N2102SJericho Air LLC · Hilton Head Island, SCBuilt 1979 · S/N 32R-7985085N2102YDotzler Richard L Jr · Harlan, IABuilt 1979 · S/N 28-7911144N2103JTaffet Jay · New Orleans, LABuilt 1978 · S/N 28-7911073N2103MMontgomery William A · El Paso, TXBuilt 1977 · S/N 28R-7837066N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660N2103XBrandon Capital Group Inc · Leland, MIS/N 32-7940084N2104HGrenier Chad · Moorpark, CABuilt 2007 · S/N 172S10432N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271N2104TAllison Jack A · Orangevale, CABuilt 1971 · S/N 28R-7135048N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444N21056N21056 LLC · Wayne, PABuilt 2007 · S/N 172S10434N2105BNwf Aviation LLC · Defuniak Springs, FLBuilt 1979 · S/N 32R-7987025N2105THolt Dennis A · Gilbertsville, PABuilt 1971 · S/N 28R-7135051N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433N2105XAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12585N21065Omni Management LLC · Decatur, ALS/N 28-7990033N2106WGemma Aviation LLC · Duncan, SCBuilt 1973 · S/N M-1474N2107GMerkle Betty Lou · Hanover, ILBuilt 1978 · S/N 28-7911068N2107UFlight World Inc · San Juan, PRBuilt 2004 · S/N 172S9603N2107VEveritt Fred Jr · Henryville, INBuilt 1979 · S/N 28-7911127N2107WIguana Aviation LLC · Chicago, ILBuilt 1973 · S/N M-1437N2108CMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7990142N2108HWise Charles · Bridgewater, MAS/N 28-7911053N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2004 · S/N 172S9605N2108VFast And Slow To Go LLC · Dover, DEBuilt 1979 · S/N 28-7911128N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207N2109LCaban-Loperena Jumil · Moca, PRBuilt 2004 · S/N 172S9609N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274N2109TCarver Aero LLC · Muscatine, IABuilt 1971 · S/N 28R-7135055N210AVCarter Jay Jr · Wichita Falls, TXBuilt 2013 · S/N 0002N210BBCherry Hill Aviation C182 LLC · Freetown, INBuilt 1979 · S/N R18201430N210BCDurant Bruno Gerard · Coalmont, TNBuilt 1998 · S/N 18280308N210DTNewell Gary · Colmar, PABuilt 2004 · S/N 23421N210EZFaulkison Brian S · Watkins, COBuilt 1978 · S/N 28-7990077N210FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496478N210GPPeers Guy W · Cresson, TXBuilt 2004 · S/N 60578N210HDPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1841-33N210HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9040N210KBIanasher LLC · Montgomery, TXS/N 28-7210017N210KHHale Greg D · Tulsa, OKBuilt 2010 · S/N 40385
Back to AD 2006-10-21