OpenAirDocs.org
AD 2009-21-10 R1

Registered aircraft · 4,274

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:2009-21-10-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:2009-21-10-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.

N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315N522FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48476N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776N522VRBank Of Utah Trustee · Salt Lake City, UTS/N 1102N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194N523FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48479N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506N523UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3960N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977N524VAN524va Trust · Wilmington, DEBuilt 2007 · S/N 3204N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692N525FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48565N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470N527ASAlaska Airlines Inc · Seatac, WAS/N 35694N527DDK&A Advisors LLC Trustee · Wilmington, DEBuilt 1987 · S/N 1040N527JCGiv Exec Jet LLC · Ithaca, NYBuilt 1991 · S/N 1179N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978N527VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3417N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695N528FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48623N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198N529FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 48624N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201N53441United Airlines Inc · Chicago, ILS/N 30131N53442United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33536N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705N534LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32572N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739N535JMWhiskey Uniform LLC · Wichita Falls, TXBuilt 1997 · S/N 1304N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203
Back to AD 2009-21-10 R1