AD 2000-22-07

Registered aircraft · 442

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

N584UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6194N585UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6214N586UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6230N587UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6236N601NKBank Of Utah Trustee · Sale Lake City, UTBuilt 2010 · S/N 4206N602NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4264N603NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4321N605NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4548N606NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4592N607NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 4595N608NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4902N609NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4951N611NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 4996N612NKRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2012 · S/N 5029N613NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5042N614NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5132N615NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5159N616NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5370N617NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5387N618NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5458N619NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5517N620NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5624N621NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5672N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327N633NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6345N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370N635NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6383N636JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2755N636NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2015 · S/N 6424N637JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2781N637NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6436N638JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2802N638NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6463N639JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2814N639NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6487N640JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2832N640NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6507N641JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2848N641NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6566N642NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6586N643JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2871N643NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6616
Back to AD 2000-22-07