Skip to content

Registered aircraft · 503

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

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 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 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 N170PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15170 N173BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19038 N176PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15176 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 N206BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19042 N207HBank Of Utah Trustee · Salt Lake City, UTS/N 15207 N209BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19043 N226BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19044 N228LHAerovision Aircraft Services LLC · Norton Shores, MIS/N 10028 N228PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15228 N232PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15232 N239LHAerovision Aircraft Services LLC · Muskegon, MIS/N 10039 N242LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 15076 N244LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15233 N245LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15234 N246LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15239 N247LRSkywest Airlines Inc · Saint George, UTBuilt 2011 · S/N 15273 N248LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15274

Back to AD 2012-22-10