OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,798

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.

N602JVFull Scale Jets LLC · Idaho Falls, IDBuilt 2020 · S/N 525-1064N6030RMaresco Services Inc · Alpha, NJBuilt 1979 · S/N E-1459N60329Beech Bumz Aviation LLC · Tarpon Springs, FLBuilt 1979 · S/N E-1473N6032UDeepark Karan Trustee · Spring, TXBuilt 1979 · S/N E-1471N6034RKelsoe Robert L · Dallas, TXFirst renewal noticeBuilt 1979 · S/N E-1474N6034XHill Farms D&K LLC · Condon, ORBuilt 1979 · S/N E-1477N60357Central Flying Service LLC · Little Rock, ARBuilt 1979 · S/N E-1478N6037MRaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N TH-1022N6037PRegistered aircraftN-number assigned, not yet registeredS/N TH-1023N6038WDidden Gary E · La Crescenta, CABuilt 1979 · S/N TH-1025N6039RRegistered aircraftBuilt 1979 · S/N E-1489N6039ZZandi Aziz · Greeley, COS/N E-1490N603AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48267N603CDWtc Pitts LLC · Coushatta, LABuilt 2019 · S/N 525-1029N603JHAirdent LLC · Trinity, FLBuilt 1978 · S/N E-1271N603MRTextron Aviation Inc · Wichita, KSS/N 208B6003N60402Bajaj Rajesh · Florence, SCBuilt 1979 · S/N E-1498N6040RSixtyforty LLC · Mequon, WIBuilt 1979 · S/N TH-1026N6045STexoma Building Services LLC · Kingston, OKBuilt 1979 · S/N BE-65N6048SWhatley Properties LLC · Muskogee, OKS/N E2061N60491Umb Bank Na Trustee · Salt Lake City, UTS/N 60491N604MDNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2004 · S/N 208B1075N604WETextron Aviation Inc · Wichita, KSS/N 208B6004N6050MAgl Aviation And Management LLC · Payson, AZBuilt 1979 · S/N E-1632N6050TGullett Aviation LLC · Palatka, FLBuilt 1979 · S/N E-1488N60519Bunn Robert Michael Trustee · Salina, KSBuilt 1980 · S/N E-1687N6051MEbe Inc · East Moline, ILBuilt 1979 · S/N E-1492N6054M6054m LLC · Morrison, ILBuilt 1979 · S/N E-1500N6058AAlpha Air LLC · Sparks, NVBuilt 1979 · S/N TH-1017N605CCommerce Landing Aviation LLC · Tampa, FLS/N TH-2081N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005N605EAChip Aviation LLC · South Pittsburg, TNBuilt 1981 · S/N LA-129N605JDM2driver LLC · Midland, TXBuilt 1996 · S/N BB-1555N605JGSeher Asset Management LLC · Shelton, WABuilt 1996 · S/N FL-158N605MJDrue Acquisitions LLC · Fort Worth, TXBuilt 2008 · S/N FL-578N605MRTextron Aviation Inc · Wichita, KSS/N 208B6005N605SNEbj Air LLC · Powell, TNBuilt 2021 · S/N 525-1097N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041N606Sale Reported · La LagunitaSale reported, pending cancellationBuilt 1987 · S/N 258068N6060ZDesert Aero LLC · Hobbs, NMBuilt 1984 · S/N E-2155N60619Ssc International Inc · Las Vegas, NVS/N 210N6067TSullivan Patrick V · Chicago, ILBuilt 2002 · S/N E-3467N6069AAt Aero LLC · Wilmington, DEBuilt 1978 · S/N BB-357N606AMSl Jet LLC · Cleveland, TNS/N 205N606CMSeagull Aviation LLC · Larkspur, CABuilt 1981 · S/N LA-163N606EFTextron Aviation Inc · Wichita, KSS/N 208B6006N606HCSundancer Enterprises LLC · Norman, OKBuilt 1994 · S/N 525-0087N606MAN606ma LLC · Burleson, TXS/N 196N606MJTack Leasing Inc · Hutto, TXS/N FL-596N606PC988sl Aviation LLC · Ridgeland, MSBuilt 1980 · S/N LJ-938
Back to AD 2006-16-18 R1