OpenAirDocs.org
AD 2009-22-06

Registered aircraft · 31

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-22-06')
    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-22-06')
  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.

N1523Msn 1523 LLC · San Diego, CABuilt 2001 · S/N 1523N505VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4798N506VLBank Of Utah Trustee · Salt Lake City, UTS/N 4828N507VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4832N508VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4950N509VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5062N510VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5207N511VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5212N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510N520VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5595N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705N608NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4902N656JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3091N659JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3190N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724N794JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4904N931TBBoeing Company · Renton, WABuilt 1998 · S/N 53532N963DNBoeing Company · Renton, WABuilt 1999 · S/N 53533N989CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 1807N991CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 1675
Back to AD 2009-22-06