OpenAirDocs.org
AD 2006-01-11 R1

Registered aircraft · 1,017

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-01-11-R1')
    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-01-11-R1')
  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.

N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077N118RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0574N119RFRandigo LLC · Wilmington, DEBuilt 2002 · S/N 208B0929N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243N12155Martinaire Aviation LLC · Addison, TXBuilt 1996 · S/N 208B0562N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564N1258BSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1258N1259KN1259k LLC · Youngstown, NYS/N 208B0974N125RFRandigo LLC · Wilmington, DEBuilt 2012 · S/N 208B2330N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250N126ESCobra Aviation Services LLC · Oklahoma City, OKBuilt 2018 · S/N 208B5315N126RFRandigo LLC · Wilmington, DEBuilt 2005 · S/N 208B1156N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055N127RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0350N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808N128DSKachemak Bay Flying Service Inc · Huntsville, ALBuilt 2016 · S/N 208B5326N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133N1293EDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1996 · S/N 208B0537N1296STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 208B1296N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079N129CGSchuman Carriage Co Ltd · Honolulu, HIBuilt 2007 · S/N 208B1290N12XVStormhaul Holding LLC · Taylors, SCBuilt 2021 · S/N 20800678N1314XWright Air Service Inc · Fairbanks, AKBuilt 2008 · S/N 208B1314N131CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0019N131RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B-0851N1323RWright Air Service Inc · Fairbanks, AKBuilt 1999 · S/N 208B0745N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777N133RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B0840N135CCCc Aviation Partners LLC · Miami, FLBuilt 2019 · S/N 208B5510N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037N13DQThaddeus Alistair Lc · New York, NYBuilt 2023 · S/N 208B5758N140ASAircraft Structures International Corp · Enid, OKS/N 208B0633N140RFAv Serv LLC · Dover, DES/N 208B0656N141RFRandigo LLC · Wilmington, DEBuilt 1986 · S/N 20800105N143CAHaugland Group Aviation LLC · Melville, NYBuilt 2019 · S/N 208B5516N143WAWright Air Service Inc · Fairbanks, AKBuilt 2012 · S/N 208B5002N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722
Back to AD 2006-01-11 R1