OpenAirDocs.org
AD 99-23-22 R2

Registered aircraft · 1,335

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

N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348N566ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35182N568ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35183N569ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35184N569CAAc Spe 11 LLC · Orlando, FLS/N 30763N570ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35185N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904N571CBKba Bridges & Shields LLC · East Point, GABuilt 1984 · S/N 001N572AA727x Aerospace Corp · Lewes, DES/N 49458N573AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53092N574AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53151N576AAFronteraflight Holdings Inc · Dover, DES/N 53153N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187N580UPC C & E I LLC · Louisville, KYS/N 25632N581AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53158N581ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35188N583AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53160N583ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35681N584ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35682N585AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53248N585ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35683N586AAAerothrust Holdings Leasing LLC · Miami, FLS/N 53249N586ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35189N587ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35684N588ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35685N589ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35686N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253N590ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35687N592ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35190N593ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35107N594ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35191N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285N595QAQuality Aviation LLC · Boulder, COBuilt 2004 · S/N C-143N596ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35688N597ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35689N59YPNextgen Flying LLC · The Villages, FLBuilt 1998 · S/N 275N600JBOgden Aviation LLC · Hinsdale, ILBuilt 1998 · S/N 272N600LYMajjec Jhett LLC · Springfield, MABuilt 2004 · S/N 337N607ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29751N608BGN A S A Lyndon B Johnson Space Center · Houston, TXS/N 430N60958Umb Bank Na Trustee · Salt Lake City, UTS/N 60958N609ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29752N610RLFalconrl LLC · Missoula, MTBuilt 1988 · S/N 68N611ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 29753N612ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30162N613ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30163N614ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30343
Back to AD 99-23-22 R2