Skip to content

AD 2000-22-02 R1

Registered aircraft · 823

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

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-02-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:2000-22-02-R1') ORDER BY n_number

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-02-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:2000-22-02-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.

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-02-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:2000-22-02-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766 N874NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31129 N87507United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31637 N87512United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33458 N87513United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31621 N87527United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38701 N87531United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39999 N875AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36705 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318 N898NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33225 N899NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2012 · S/N 31151 N901ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29503 N901NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33226 N902ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29504 N902NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31154 N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505 N903NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31153 N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506 N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155 N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509 N907NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31158 N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510 N908NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31157 N909ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29511 N909NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31159

Back to AD 2000-22-02 R1