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.

N4598VLandwell Pllc · Lake Havasu City, AZBuilt 1947 · S/N D-1151N459ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36352N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084N459JDWilson John K · Rosamond, CABuilt 1970 · S/N E-210N459MARani9650 LLC · Lathrop, CABuilt 1975 · S/N BB-36N459MBSt Pete Flight LLC · Saint Petersburg, FLS/N 5600438N459WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 208B5428N45AFCenturion Air LLC · Draper, UTBuilt 1978 · S/N 5010284N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142N45JRJmf Inc · St Maries, IDBuilt 1976 · S/N 421C0109N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635N45LCBelle Robert M · Tampa, FLBuilt 1979 · S/N E-1600N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384N45PTCleaver Anthony M · Boulder, COBuilt 1976 · S/N TH-727N45RCClassic Ag Aviation LLC · Kingston, OKBuilt 1990 · S/N 560-0071AN45SADavis Aviation Inc · Brandon, MSBuilt 1980 · S/N LJ-903N45TLNbb II LLC · New Orleans, LAS/N 5010016N45WWHolmes Bruce Arthur · Maricopa, CABuilt 1977 · S/N E-1203N4600SCozzolino Aerosports II LLC · Indianapolis, INBuilt 1975 · S/N E-771N4604AThomas Douglas E · Grove City, PABuilt 1970 · S/N E-216N4605MJohnson Plane Services LLC · Greenbrier, TNBuilt 1978 · S/N E-1246N4607MClark Jean F Trustee · North Falmouth, MABuilt 1978 · S/N TH-938N4608ATriplett Robert J · Cameron, WIBuilt 1970 · S/N E-217N460EMEaglemed LLC · Wichita, KSBuilt 2000 · S/N LJ-1593N460RMMustang Two LLC · Newport Beach, CABuilt 2016 · S/N 525-0926N4610WTen Right Aviation LLC · Abbeville, LAS/N TH-1378N4613MMott John H · Lafayette, INBuilt 1978 · S/N E-1245N4615CNorth American Flight Services Inc · Ballston Spa, NYBuilt 1991 · S/N LJ-1273N4615SMurrer Aviation Inc · Canonsburg, PAS/N TH-685N4619MNfv LLC · Helena, MTBuilt 1978 · S/N TH-918N461ARSolo Energy Drink Inc · Miramar, FLFirst renewal noticeS/N 384N461ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 36363N461BCB&K Leasing Inc · Nantucket, MABuilt 1992 · S/N TH-1661N461EPGreenbush Seed & Supply Inc · Parsons, KSS/N LJ-1697N4621MBassline Logistics LLC · Watauga, TNS/N TH-919N4625BMartinaire Aviation LLC · Addison, TXS/N 208B0159N4625MSchuster Alexander · Santa Rosa, CABuilt 1978 · S/N E-1247N462ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 36361N462BJd Russell Co · Tucson, AZBuilt 1989 · S/N 560-0016N462JSState Of Iowa · Des Moines, IABuilt 2024 · S/N 208B5817N463AKFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 162N463DBThunderhook Air Inc · Brentwood, TNBuilt 2009 · S/N 20800505N463KBBuster Air LLC · Miami, FLBuilt 1972 · S/N TH-278N463RSRts Aviation LLC · Atlanta, GABuilt 1987 · S/N LJ-1143N4648LAquarius Investments LLC · Veguita, NMBuilt 2025 · S/N 525-1199
Back to AD 2006-16-18 R1