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.

N6182XHillman Paul L · Cleverdale, NYBuilt 1981 · S/N E-1971N6184SCapps David E · Dallas, TXS/N E-3553N6185CFry Barry J · Boyce, VAS/N E-1972N61881United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42200N61882United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42201N61886United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42190N61887United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42192N6188MDanze Alex · Riverside, CABuilt 1982 · S/N TH-1318N61898United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62815N618ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30543N618BHTkr3 Aviation LLC · Urbandale, IABuilt 1990 · S/N E-2543N618GHDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N 513N618JGChris Jenschke LLC · Poteet, TXBuilt 1995 · S/N 650-7055N618KCiholas Aviation LLC · Newburgh, INBuilt 1991 · S/N 560-0149N618LKRvr Air Charter LLC · Fort Worth, TXBuilt 1986 · S/N S550-0108N618PGRegistered aircraftBuilt 2017 · S/N 525-0972N618USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21122N6190SAir Logistics LLC · Savannah, GAS/N LJ-1702N6191YChisum Robert · Lorenzo, TXS/N D-27N6198AEdwards Thomas M · New Tazewell, TNBuilt 1981 · S/N E-1976N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336N619ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30164N619CARssd Properties LLC · Kilgore, TXBuilt 2025 · S/N 525-1186N619DDPark Avenue Group Inc · Stuart, FLBuilt 1980 · S/N BE-92N619HPLofty Group LLC · Carmel, CABuilt 1992 · S/N 5600165N619LBLba Investments LLC · Dover, DEBuilt 2011 · S/N FL-749N619MAKenmore Air Harbor LLC · Kenmore, WABuilt 2010 · S/N 208B2192N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458N619RDHunt Aviation LLC · Rochester, MNS/N E-2830N619TCRedhawk Partners LLC · Sumter, SCBuilt 2010 · S/N 525-0698N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457N61APTrewhitt Jamie Mcmahan · Pacific Palisades, CAS/N BB-1192N61AYAonvo Investment LLC · North Miami, FLS/N BB575N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438N61GKOverdrive Aviation LLC · Cantonment, FLBuilt 2007 · S/N 560-0771N61GNGuardian Flight LLC · Lewisville, TXS/N LJ-1421N61HAMighty Horn Ministries Inc · Lebanon, OHBuilt 1978 · S/N 501-0044N61JV61jv LLC · Chuckey, TNS/N 421C0097N61KATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N FA-200N61LPRossetter Eric · Lafayette, CABuilt 1981 · S/N E-1807N61PCN61pc Leasing LLC · Ponca City, OKBuilt 1994 · S/N BB-1483N61PEHc4 LLC · Fair Play, SCBuilt 1983 · S/N BB-1132N61PZRoughneck Supply LLC · Muskogee, OKBuilt 1982 · S/N TH-1352N61SGNion LLC · New Century, KSBuilt 1996 · S/N 5250155N61SJByrum Lyle Trustee · Roswell, NMBuilt 1983 · S/N 081N61SMSma Aero LLC · Benton, KSBuilt 1970 · S/N E-199N61THBlue Heron Aviation LLC · Orwigsburg, PABuilt 1984 · S/N FA-17N61TYDcc Aviation LLC · Southaven, MSBuilt 1997 · S/N 525-0186N61WAWacouta Aircraft Leasing LLC · Las Vegas, NVBuilt 2025 · S/N 20800718N6200HTnr Aircraft Holdings LLC · Englewood, COBuilt 1987 · S/N 258087
Back to AD 2006-16-18 R1