AD 2016-08-18

Registered aircraft · 399

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:2016-08-18')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-18')
  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.

N356DBCaldwell Island LLC · Sherborn, MABuilt 1978 · S/N 31-7852056N357SAFox Aircraft LLC · Wasilla, AKBuilt 1980 · S/N 31-8052162N3582PAir Arctic Inc · Fairbanks, AKS/N 31-8052103N35834Carto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052115N3587PMsm587p LLC · Jericho, NYS/N 31-8052120N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144N35RDIngersoll Grove LLC · Springfield, MABuilt 1977 · S/N 31-7852039N369KJGrace Aire Inc · Corpus Christi, TXBuilt 1978 · S/N 31-7852108N36PBMarin Pacific International LLC · Apple Valley, CABuilt 1973 · S/N 31-7405128N371MCSale Reported · Palm City, FLSale reportedS/N 31-7405409N3746PSale Reported · Fort Lauderdale, FLSale reported, canceledS/N 31-7752095N376NCLima Delta Company Trustee · New Castle, DEBuilt 1977 · S/N 31-7852048N385RMG Force Air LLC · Columbus, OHBuilt 1978 · S/N 31-7852125N38KCChanney Aviation Group LLC · Las Vegas, NVBuilt 1983 · S/N 31-8352033N38MCGulf Air Aviation · Wilmington, DES/N 31-7405476N3VMAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1973 · S/N 31-7305069N400HMBarneys Services Inc · Newton, IABuilt 1979 · S/N 31-8052030N400RAJacko Josh E · Anchorage, AKBuilt 1974 · S/N 31-7405167N4023Maighnath Melissa · Jamaica, NYS/N 31-8152067N403RGGkids Holdings LLC · New York, NYS/N 31-7952219N4043MPremier Air Charters Inc · Coram, NYBuilt 1980 · S/N 31-8152001N404ABcj LLC · Haines City, FLBuilt 1981 · S/N 31-8252004N4072LN4072l LLC · Conroe, TXBuilt 1980 · S/N 31-8152019N4073LColumbia Asset Trust Corp Trustee · Wichita, KSS/N 31-8152029N4074FMy Flyers LLC · Valley Stream, NYS/N 31-8052164N4076TMike Jones Aircraft Sales Inc · Murfreesboro, TNBuilt 1980 · S/N 31-8152046N4078BDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 31-8152055N4078JStar Marianas Air Inc · Tinian, MPBuilt 1980 · S/N 31-8152057N40796Grant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 31-8152084N4079HWarbelow'S Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152074N4082TWarbelows Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152089N4083W13 Aviation LLC · Leesburg, GABuilt 1981 · S/N 31-8152099N4086EJj Aviation LLC · Allentown, PABuilt 1981 · S/N 31-8152114N40872Ole South Aviators LLC · Athens, GAS/N 31-8152134N4087CSherry-Aire LLC · Sidney, MTBuilt 1981 · S/N 31-8152125N4087KAggie Air Inc · Clifton, TXBuilt 1981 · S/N 31-8152129N4090UIsland Bound LLC · Dunedin, FLS/N 31-8152147N40919Asb1 Group LLC · Miramar, FLS/N 31-8152162N4095YLakeland Air 6 LLC · Lakeland, FLBuilt 1981 · S/N 31-8152181N40978Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 31-8152199N4097KSwag Aviation LLC · Labelle, FLBuilt 1981 · S/N 31-8152191N4098AJaa Holdings LLC · Springfield, ILBuilt 1981 · S/N 31-8152200N40992Awmr LLC · Conroe, TXBuilt 1982 · S/N 31-8252045N4101NGateway Of Sturgis LLC · Sturgis, MIBuilt 1981 · S/N 31-8252010N4102JCarto Flight Inc · Willoughby, OHBuilt 1981 · S/N 31-8152158N4104KStar Marianas Aviation School Inc · Tinian, MPBuilt 1982 · S/N 31-8252018
Back to AD 2016-08-18