OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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-16-18-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-16-18-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.

N10TBDalks Leasing Inc · Wilmington, DES/N FL-499N10TDPrairie Air LLC · Aberdeen, SDBuilt 1991 · S/N 560-0096N10TNPacific Rim Management LLC · Downey, CAS/N 257085N10VZBlanco Air Services LLC · Houston, TXBuilt 1997 · S/N FL170N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310N10XJNext Phase Ia LLC · Las Vegas, NVS/N LW-117N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666N11007Coastal Elite Air LLC · Helena, MTBuilt 1979 · S/N 501-0118N1100GKcd Enterprises Inc · Bartlesville, OKBuilt 1996 · S/N E-3049N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475N1107UBeech Air LLC · Carolina Beach, NCS/N E-3077N1108N08n Inc Trustee · Wilmington, DEBuilt 1997 · S/N E-3078N110BMDrewcy Inc · Wilmington, DEBuilt 1978 · S/N LW-273N110ECState Of Tennessee · Nashville, TNBuilt 2007 · S/N FL-558N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792N110GDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258713N110JBIngles Markets Inc · Asheville, NCBuilt 1981 · S/N 501-0172N110PEMission Aviation Fellowship · Nampa, IDBuilt 2000 · S/N 208B0858N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481N110WSPack Wikert II LLC · Anchorage, AKBuilt 1998 · S/N 258388N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486N1111SStockbridge General Contracting Inc · Clovis, CABuilt 2022 · S/N 525-1111N1112BTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2017 · S/N FL-1112N1112JJedco Properties LLC · Ruston, LABuilt 1997 · S/N TH-1822N1113XRegistered aircraftBuilt 1997 · S/N TH-1813N1114AEvans David J · Parker, COS/N 208B0309N1114JWarren Shelburne Michael · Chattanooga, TNBuilt 1997 · S/N E-3072N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559N1114XAlyeska Aero LLC · Wilmington, DEBuilt 1996 · S/N E-3055N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356N1115ZBurks Rickey D · Boerne, TXBuilt 1996 · S/N E-3015N1116AMaher Thomas J · Charlotte, NCBuilt 1997 · S/N E-3073N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402N1116WAvion Capital Corp · Anchorage, AKBuilt 1994 · S/N 208B0411N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6N111ALBc Builders Inc · Temecula, CAS/N TH484N111AWC&A Aviation LLC · Mcintyre, GABuilt 1977 · S/N TH-841N111CAKingmax Aviation LLC · Miami, FLBuilt 1982 · S/N LA-201N111DXRockwood Investments LLC · Calexico, CAS/N FL-547N111ENPecos Air Inc · Roswell, NMS/N LA-230N111FFabair LLC · Milwaukee, WIBuilt 1991 · S/N 650-0197N111GEBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 525-0661N111GJMalik Hassan · Richfield, OHBuilt 1980 · S/N 5510187N111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEBuilt 1974 · S/N LW-84N111JJTextron Aviation Inc · Wichita, KSS/N 208B5988N111KCSherrmore LLC · Winter Park, FLBuilt 1990 · S/N LJ-1258N111MIngram Industries Inc · Nashville, TNBuilt 2019 · S/N FL-1188
Back to AD 2006-16-18 R1