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.

N4309SGsi · Temple, TXBuilt 1975 · S/N E-682N430AMJems Air Inc · Glenwood, MDBuilt 2000 · S/N 560-0542N430BTDry Valley Investors LLC · Cleveland, TNBuilt 2001 · S/N 5250451N430DDN430dd LLC · Athens, TXBuilt 1985 · S/N BB-1243N430EMEaglemed LLC · Wichita, KSBuilt 2000 · S/N LJ-1616N430FMCygnus Inc · Sioux Falls, SDBuilt 2000 · S/N E-3319N430JFAusome Aviation LLC · Atlanta, GABuilt 2004 · S/N 525-0530N430MCDenault John B III · Fullerton, CABuilt 1981 · S/N BB-904N430PTN430pt LLC · Chino, CABuilt 1985 · S/N 430N430RTTortorigi Aviation LLC · Birmingham, ALBuilt 1984 · S/N TH-1411N430RVVermejo Aviation LLC · Boulder, COBuilt 2004 · S/N TH-2097N430SN430s LLC · Mesa, AZS/N BB1080N430SALks Aviation LLC · Birmingham, MIBuilt 1994 · S/N 650-7041N430TATeam Aero LLC · Olathe, KSS/N 560-0533N430TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 20800682N430UHTextron Aviation Inc · Wichita, KSS/N 525-1430N431ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43255N431BGBismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N LJ-933N431DCDiesel Acquisitions LLC · Milpitas, CAS/N FL-431N431MSTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1987 · S/N S5500127N431SCJochl Sports Inc · Banner Elk, NCBuilt 1989 · S/N BB-1337N431ZTZimin Transportation LLC · South Naknek, AKBuilt 1976 · S/N BC-18N4324VTriple Aaa LLC · Garden City, KSBuilt 2001 · S/N TH-2014N432DLWhitecotton William W · Eldersburg, MDBuilt 1974 · S/N TH-561N432PPatterson Aviation LLC · Midland, TXBuilt 2006 · S/N 525-0624N432PKX-Press Charter Services Inc · Longview, TXBuilt 1990 · S/N FL30N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293N432TXStagg Air LLC · Midland, TXBuilt 1991 · S/N 560-0154N4331ECmb Holdings LLC · Logansport, INBuilt 2000 · S/N E-3331N4331WRicca Gregory F Trustee · Bentonville, ARBuilt 1974 · S/N TH-436N433ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41704N433BOhlinger Mark A · Copley, OHBuilt 1948 · S/N D-1441N433HCKrabby Apple Trading LLC · Wilton, CTS/N BB-1807N433JMN433jm LLC · Dallas, TXBuilt 1983 · S/N BB-1174N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N434ARTwin Otter Support Services LLC · Las Vegas, NVBuilt 1974 · S/N 432N434ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 61620N434ZTZimin Transportation LLC · South Naknek, AKBuilt 2007 · S/N FL-561N435ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43292N435DGV1 Corp · Fort Lauderdale, FLS/N E-3500N435JMBonanza A36 LLC · Nashville, TNBuilt 1975 · S/N E-762N435MGonzalez Frank · Sun Valley, CABuilt 1992 · S/N E-2726N435MSPuragain Water LLC · Escondido, CAS/N 054N435MTSouthwest Aviation Solutions LLC · Las Vegas, NVBuilt 2007 · S/N 208B1305N4362WReaume Andrew G · Wayne, PABuilt 1974 · S/N E-557N4365UWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0253N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953N436DGGetting Dean W · Fort Dodge, IABuilt 1978 · S/N E-1213N436EAN436ea LLC · Sanford, FLBuilt 1997 · S/N BB-1576N436EUStevann Farms Ltd · De Witt, IABuilt 2005 · S/N E-3612
Back to AD 2006-16-18 R1