Skip to content

Registered aircraft · 1,354

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-05-21') 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-05-21') 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-05-21')
    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-05-21')
  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-05-21')
  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-05-21')
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.

N897UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3269 N898CAAc Spe 14 LLC · Orlando, FLBuilt 2011 · S/N 1208 N898UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3311 N899UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3342 N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617 N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636 N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519 N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566 N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909 N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255 N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387 N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420 N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427 N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443 N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479 N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490 N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523 N922USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6537 N923JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 5960 N923USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6543 N924USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6569 N925UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6613 N926UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6618 N927UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6625 N928AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7515 N929AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7525 N929JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6031 N930AUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7539 N931AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7541 N932AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7419 N933AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7564 N934AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7500 N934JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6130 N935JBJet Blue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6185 N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245 N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483

Back to AD 2000-05-21