Skip to content

Registered aircraft · 920

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

N100VEEpcvip Air LLC · Wilmington, DEBuilt 2012 · S/N 8113 N101CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2022 · S/N 7625 N112VLBank Of Utah Trustee · Salt Lake City, UTS/N 8011 N116BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19028 N120BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19029 N124BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19030 N131EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15217 N132EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15219 N133EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15222 N134EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15223 N135EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15225 N136EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15226 N137EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15227 N138EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15235 N141SHLead And Steel 4 LLC · Fountain Valley, CABuilt 1997 · S/N 7206 N146PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15146 N147PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15147 N150BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19032 N153PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15153 N154EAAaa Airplane LLC · Smyrna, TNBuilt 2002 · S/N 7629 N160BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19033 N161PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15161 N162PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15162 N166PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15166 N167BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19034 N168SW8075 LLC · Wilmington, DEBuilt 2007 · S/N 8075 N170PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15170 N17156Bank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 7156 N17217Wells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7217 N173BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19038 N176PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15176 N1800CGazillion Air LLC · Chapin, SCBuilt 1999 · S/N 7351 N181GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15204 N181PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15181 N182GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15175 N183GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15209 N184GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15169 N185GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15185 N186GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15165 N186PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15186 N187GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15180 N187PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15187 N195PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15195 N197PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15197 N200PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15200 N201XJRi Challenger I LLC · Beverly, MABuilt 1997 · S/N 7187 N206BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19042 N207HBank Of Utah Trustee · Salt Lake City, UTS/N 15207 N207PSSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7873 N209BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19043

Back to AD 2016-14-07