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.

N1163JBottom Line Aviation LLC · Scranton, NDS/N 163N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N1166LNovack Edward A · Cairo, NYBuilt 1965 · S/N 328N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116BBretana Charles Jr · Prescott, AZS/N E006N116BKDacy Roy W · Rockport, TXS/N 32-782N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CWJazun Carlos Walter · Parker, COBuilt 2015 · S/N 0073385N116DHHoover David · Foster City, CAFirst renewal noticeBuilt 1990 · S/N 0001N116DWWalters Douglas B · Templeton, CABuilt 2020 · S/N 21807N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019CN116GWMajestic Airlines Inc DBA · Lynden, WABuilt 1970 · S/N 31-662N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167N116JMMorgan James E · Everett, WABuilt 2009 · S/N RV20260N116JTParks Kevin J · Arlington, TNBuilt 2009 · S/N 80982N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116LTMarrow Henry G · Southern Pines, NCBuilt 2013 · S/N 6090N116MFWeber Donald E · Saint David, AZS/N 27-3522N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061N116RJRegistered aircraftS/N 3227N116SB114b Holding Inc Trustee · Wilmington, DEBuilt 2000 · S/N 14678N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426N116TBMcmullan Francis G · Weirsdale, FLS/N 362N116TSIrish Cindy L · Buckeye, AZBuilt 2003 · S/N 60399N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1170LSweet Aviation LLC · Dover, DES/N 332N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587
Back to AD 2006-10-21