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.

N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N529CGCargo Aircraft Management Inc · Wilmington, OHS/N 529 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153 N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705 N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989 N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739 N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993 N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784 N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041 N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398 N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050 N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082 N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107 N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134 N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843 N544UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4847 N545UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4850 N546UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4885 N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849 N549UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4932 N551UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2011 · S/N 4940 N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861 N552UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4957 N553SXUmb Bank Na Trustee · Salt Lake City, UTS/N 3171 N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960 N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898 N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244 N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292 N560UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5300 N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927 N561UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5317 N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622 N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N562UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5332 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N563UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5368 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031

Back to AD 2000-05-21