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.

N76515United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31623N76516United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37096N76517United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31628N76519United Airlines Inc · Chicago, ILBuilt 2010 · S/N 30132N76522United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31660N76523United Airlines Inc · Chicago, ILBuilt 2010 · S/N 37101N76526United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38700N76528United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31663N76529United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31652N76532United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62749N76533United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62748N7654NE W Merritt Farms · Porterville, CABuilt 1968 · S/N E-116N7659NPintail Investment Properties LLC · New Bern, NCBuilt 1968 · S/N E-78N765BDukerson Air LLC · Broken Arrow, OKBuilt 2003 · S/N E-3494N765CFCs Air LLC · Osage Beach, MOBuilt 1987 · S/N TH-1528N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259N765TJohnson Adam D · Denton, TXS/N E-404N765WAValiair Lc Trustee · Casper, WYBuilt 1980 · S/N BB-765N765WFKofel Aviation LLC · Clayton, GABuilt 1974 · S/N TH-523N766CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34016N7671GPremier Aviation LLC · Philadelphia, MSBuilt 1980 · S/N E-1671N7672NKruco Inc · Spring Valley, MNBuilt 1968 · S/N E-87N767ARMontenecourt Aviation LLC · Wilmington, DEBuilt 1984 · S/N TH-1407N767CKKalitta Air LLC · Ypsilanti, MIBuilt 2005 · S/N 34017N767CMValiair Lc Trustee · Casper, WYBuilt 1992 · S/N E2723N767DFMaurin Edward E III · Grand Junction, COBuilt 1988 · S/N E-2403N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262N767JCCole Jeffrey E · Rockwall, TXS/N E-797N767JPPicard Philip A · Clover, SCBuilt 1990 · S/N TH-1583N767KCBig Orange Sky LLC · Green Bay, WIBuilt 1999 · S/N 560-0517N767MCMonument Aviation LLC · North Chesterfield, VABuilt 1973 · S/N LJ-595N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401N7687NFreedom Flying Inc · Wilmington, DEBuilt 1968 · S/N E-94N768CKKalitta Air LLC · Ypsilanti, MIS/N 34018N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263N768JSSfh Inc DBA · Fargo, NDBuilt 2005 · S/N 560-0775N7690NSpencer Alan R · Peyton, COBuilt 1968 · S/N E-92N7691NHawk Robert S · Argyle, TXBuilt 1968 · S/N E-93N769BJBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N FL-1040N769SLSanta Ynez Films · Malibu, CABuilt 1980 · S/N LA-20N76ACTennessee Aviation Company LLC · Knoxville, TNBuilt 1980 · S/N E-1791N76AZHubbard Broadcasting · Saint Paul, MNBuilt 1988 · S/N 20800139N76BAWestphal Jon A · Menomonie, WIBuilt 1975 · S/N E-783N76GPGp Flight Group LLC · Petaluma, CABuilt 2023 · S/N 525-1151N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N76NB12 Parsecs LLC · Manhattan, KSBuilt 1975 · S/N E-791N76PM2012 Leasing Inc · Saint Paul, MNBuilt 1998 · S/N FL-200N76TFFca LLC · Leawood, KSBuilt 1997 · S/N 560-0431N76VCBel Air Holdings Inc · Wilmington, DEBuilt 1982 · S/N TH-1361N76YTJack Straw Development LLC · Tempe, AZBuilt 2009 · S/N 525-0687
Back to AD 2006-16-18 R1