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.

N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203 N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828 N959BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60959 N959NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33329 N960ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29542 N960NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33330 N961ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30092 N961NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31205 N962ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30858 N962BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60962 N962NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33331 N963ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29543 N963NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31208 N964ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30093 N964NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31210 N965ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29544 N965NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33239 N966ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30094 N966NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33240 N967ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29545 N967NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31214 N968ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30095 N968NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33241 N969ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29546 N969NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31215 N970ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30096 N970NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31218 N970STNational Nuclear Security Administration · Albuquerque, NMBuilt 2008 · S/N 29645 N971ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29547 N971NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31217 N972ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30097 N972EXBallair Aviation Holdings LLC · Laud By Sea, FLBuilt 1991 · S/N 24645 N972NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33334 N973ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29548 N973NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31219 N974ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30098 N975ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29549 N976ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30099 N976JMBank Of Utah Trustee · Salt Lake City, UTS/N 29190 N976NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 33243 N977NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31225 N978ANMsn 30100 Trust · Wilmington, DEBuilt 2001 · S/N 30100 N978NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31226 N979ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 29568 N979NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31228 N980ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33203 N980NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31229 N981ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29569 N981NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31230 N982ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31067

Back to AD 2000-22-02 R1