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.

N2439TSkylane 2439t Partners LLC · Burlingame, CABuilt 2000 · S/N 18280810N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450N243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338N243CYHarvey Steven T · Honolulu, HIBuilt 2000 · S/N 2081N243DBMainpro Inc · Alexandria, KYBuilt 2002 · S/N 2315N243EHVeracity Aviation LLC · Seguin, TXS/N 3482N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019N243JGBateman Scott R · Montrose, CABuilt 2001 · S/N 80669N243JHFlowers Derrick W · San Antonio, TXBuilt 2016 · S/N 20454N243JWUhles Denny · Bakersfield, CABuilt 1983 · S/N 243N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243N243MDWhiteis Barnabas G · Apex, NCBuilt 1997 · S/N 20665N243MEMcaleer William V Jr · Milledgeville, GABuilt 2000 · S/N 20608113N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708N243PSN9089 LLC · Lewes, DES/N 3257073N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595N243SDSouth Dakota State University · Brookings, SDBuilt 2024 · S/N 4496576N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212N243TJJones Helicopters LLC · Villa Rica, GABuilt 2004 · S/N 10239N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095N243YShilt Jerry C · El Dorado Springs, MOBuilt 2005 · S/N 3288N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136N2440QTeanaway Ventures Consulting LLC · Cle Elum, WABuilt 2001 · S/N 18280937N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169N24429Pniak Robert J · Carmel Valley, CABuilt 2000 · S/N 18280700N2442QCoastal Business Systems Inc · Eureka, CABuilt 2001 · S/N 18280938N2442VBarts Flying Service Inc · Storm Lake, IABuilt 1980 · S/N 36-8060017N2443HSilver Star Jet LLC · Delafield, WIBuilt 2000 · S/N 18280702N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874N2445JBuzzard Aviation Inc · Freer, TXBuilt 2000 · S/N 20608095N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720N2445VN2445v Cessna Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280699N2446ASkybound Aviation LLC · Bixby, OKBuilt 2000 · S/N 18280695N2446ESugarloaf Air LLC · Wilmington, DES/N T20608580N2446REdgon Inc · Orlando, FLS/N 18280697N2446SFerreby Thomas E · Stroudsburg, PABuilt 2000 · S/N 18280698
Back to AD 2006-10-21