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.

N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393VWayne Brett M · Saint George, UTS/N HAY 0001N1394JFendi Aviation LLC · Petal, MSS/N 394N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392N1395JWard Brian S · Long Beach, CABuilt 1975 · S/N 395N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673N13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1970 · S/N 27-4581N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600N13984Smith Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N 27-4602N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720N1398HMiller Debra L · Anchorage, AKS/N 15AC-449N1398JPrivedenynk Sergey · Springfield, MABuilt 1975 · S/N 398N13998Granger Vic · Union Grove, ALS/N 27-4616N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92N139BCTrombley Steven T · Worland, WYBuilt 2008 · S/N 506-2008N139BKInternational Air Service Inc Trustee · Carson City, NVBuilt 1981 · S/N 139N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570N139CPLai LLC · Pearl, MSS/N 18073CN139DBWolfe LLC · Rogers, TXS/N 27-4611N139DMMurillo Raymond A · Pico Rivera, CABuilt 1969 · S/N 28R-35262N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174N139MWhitney Richard T · Steamboat Springs, COBuilt 2015 · S/N 3239N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541N139NLowery William D · Geneva, FLBuilt 2020 · S/N 001N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195N139TFWithrotor Aviation Inc · Lakeview, ORBuilt 2009 · S/N 82465N139TWMcghee James Allen · Houston, TXBuilt 2002 · S/N 172S9139N139UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11488N139WTCotton Business Enterprises LLC · Hummelstown, PABuilt 2000 · S/N 27-0283N13AHCasady Joseph P · Buckley, WABuilt 1995 · S/N 1334N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009N13AVGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-028N13BDLinenfelser Charles D · Hardy, VABuilt 1987 · S/N 1357N13BFWygant Steven J · Copper Center, AKBuilt 2008 · S/N 3021N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532N13BSSteele Roger H · Cedar City, UTS/N 1259N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411
Back to AD 2006-10-21