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.

N18457Colwell Arthur R · Magnolia, TXBuilt 1977 · S/N E-1133N18459Iglesia De Cristo · Porter Ranch, CABuilt 1977 · S/N E-1134N18462Sayers James B · Edison, OHBuilt 1977 · S/N E-1140N18463Bickett James C · Central City, KYS/N E-1137N18466Pantaxios LLC · Spencerport, NYBuilt 2019 · S/N 525-1034N18469Bonanza 469 LLC · Visalia, CABuilt 1977 · S/N E-1141N1846WChristenson R Darren DBA · Vernal, UTBuilt 1977 · S/N E-1138N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N18474Sacandaga Air Inc · Fort Plain, NYS/N E-1309N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455N1848XTeo Steel Inc · Ramer, TNBuilt 1981 · S/N E-1919N18496Willy P Air LLC · Fort Myers, FLBuilt 1977 · S/N E-1153N1849LSpillman George R Jr · Argyle, TXBuilt 1976 · S/N E-848N1849WCarrow LLC · Meredith, NHBuilt 1973 · S/N E-428N184AJFour Alpha Juliet LLC · Minster, OHBuilt 2004 · S/N E-3578N184DNorth Country Holdings LLC · Moses Lake, WABuilt 1987 · S/N FA-132N184DMRegistered aircraftBuilt 1998 · S/N E-3199N184GPGpj 184 LLC · Newport Beach, CABuilt 1994 · S/N 650-0236N184PABartowjets LLC · Wilmington, DEBuilt 1981 · S/N 318N184SKBank Of Utah Trustee · Salt Lake City, UTS/N 28284N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184N184XTitan Island Aviation LLC · Houston, TXS/N 421C0824N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N185HP185hp LLC · Sioux Falls, SDBuilt 1982 · S/N E-1996N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034N1860AAry Co Ac & Heat LLC · Decatur, TXBuilt 1981 · S/N E-1933N1861FKent Group Inc · Hazelhurst, WIBuilt 1981 · S/N E-1940N1861MLightspeed Enterprises LLC · Virginia Beach, VABuilt 1981 · S/N E-1936N1865CHotel Alpha LLC · Tampa, FLBuilt 2007 · S/N 525-0647N1867State Of Alaska · Anchorage, AKS/N FL-815N1868WJohnson Brian D · Glidden, IABuilt 1973 · S/N E-436N186ALAlm Holdings Delaware LLC · Wilmington, DES/N 186N186DLAesop LLC · Las Vegas, NVBuilt 2013 · S/N 525-0803N186SGFeet Wet Aviation LLC · Scottsdale, AZBuilt 2008 · S/N 20800504N186TWTnp Aviation LLC · Valdosta, GABuilt 2001 · S/N 525-0416N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239N1870WMahoney Michael A · Daphne, ALBuilt 1973 · S/N E-435N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1875LRib-Cjr Aero LLC · Los Altos Hills, CABuilt 1976 · S/N E-852N1875WN1875w LLC · Nashville, TNBuilt 1973 · S/N E-437
Back to AD 2006-16-18 R1