Skip to content

Registered aircraft · 549

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

N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 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 N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739 N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398 N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849 N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861 N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927 N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622 N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031 N566JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2042 N567AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4567 N568JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2063 N569JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2075 N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099 N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125 N579JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2132 N580JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2136 N583JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2150 N584JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2149 N585JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2159 N586JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2160 N587JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2177 N588JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2201 N589JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2215 N590JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2231 N591JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2246 N592JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2259 N593JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2280 N594JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2284 N595JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2286 N597JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2307 N598JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2314 N599AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4599 N599JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2336 N601AWAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 1935

Back to AD 2017-12-13