Skip to content

Registered aircraft · 688

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:2007-13-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:2007-13-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:2007-13-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:2007-13-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:2007-13-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:2007-13-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.

N133SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000452 N134HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000220 N134SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000458 N135HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000224 N135SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000460 N136HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000228 N136SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000462 N137HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000231 N138HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000234 N138SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000466 N139SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000468 N140SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000470 N141SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000472 N142SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000475 N143SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000476 N144SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000482 N145SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000484 N146SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000491 N148SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000492 N149SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000495 N150SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000499 N151SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000503 N152SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000549 N153SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000553 N154SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000556 N156SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000557 N157SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000558 N160SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000568 N161SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000569 N162SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000576 N163SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000577 N164SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000603 N165SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000613 N166SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000615 N167SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000616 N168SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000617 N170EHHoneywell Aerospace US LLC · Phoenix, AZBuilt 2004 · S/N 17000059 N170SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000483 N170XYSwiflite Aircraft Corp · Houston, TXBuilt 2008 · S/N 17000241 N171SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000485 N173SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000486 N174SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000517 N175RSAng USA III LLC · Naples, FLBuilt 2006 · S/N 17000141 N175SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000527 N176RSAng USA I LLC · Naples, FLBuilt 2005 · S/N 17000107 N176SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000533 N177RSAng USA II LLC · Naples, FLBuilt 2006 · S/N 17000112 N177SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000535 N178SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000555 N179RSAng USA IV LLC · Naples, FLS/N 17000146

Back to AD 2007-13-13