Skip to content

Registered aircraft · 883

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-17-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-17-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-17-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-17-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-17-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-17-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.

N500CGAmalgamated Consolidated LLC · Pittsburgh, PABuilt 2024 · S/N 21032 N500FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20924 N501FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20925 N501KAAllen Aircraft Equipment LLC · Valparaiso, INBuilt 2024 · S/N 21002 N502FX95 Management LLC · Cleveland, OHBuilt 2022 · S/N 20929 N503FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20930 N503KJCrawford Leasing Company LLC · Wichita, KSBuilt 2007 · S/N 20188 N504FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20933 N505FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20934 N506FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20941 N507FXSempra Energy · Cleveland, OHBuilt 2023 · S/N 20947 N508FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20952 N508XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 20008 N509FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20953 N509SBSbco Cj3 LLC · Denver, COBuilt 2015 · S/N 20580 N50LFLeprino Foods Co · Denver, COBuilt 2014 · S/N 20511 N510FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20963 N511FCMaryland Group LLC · Saint Louis, MOBuilt 2006 · S/N 20141 N511FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20964 N512FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20978 N513FXMotorola Solutions Inc · Cleveland, OHBuilt 2024 · S/N 20995 N514FXBanks Lee C Trustee · Cleveland, OHBuilt 2024 · S/N 20998 N515VRDream 1 LLC · Carson, CABuilt 2014 · S/N 20530 N516FXC View LLC · Cleveland, OHBuilt 2024 · S/N 21010 N516WP516wp LLC · Boca Raton, FLBuilt 2007 · S/N 20178 N516WRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 20980 N517FXFlexjet LLC · Cleveland, OHBuilt 2005 · S/N 20038 N518FXFlexjet LLC · Cleveland, OHBuilt 2005 · S/N 20046 N520RPEcho Acquisitions LLC · Dover, DEBuilt 2004 · S/N 20032 N522ADCindago LLC · Rancho Cucamonga, CABuilt 2016 · S/N 20664 N524FXFlexjet LLC · Cleveland, OHBuilt 2006 · S/N 20095 N525FXFlexjet LLC · Cleveland, OHBuilt 2006 · S/N 20112 N5262State Street Corp · Shelton, CTBuilt 2006 · S/N 20122 N527FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20124 N527HRegistered aircraftBuilt 2023 · S/N 20986 N527WRBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 20965 N528FXCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20125 N529NNAudubon Leasing LLC · Eden Prairie, MNBuilt 2022 · S/N 20906 N530FXCitation X Parts LLC · Liberty, NCBuilt 2007 · S/N 20148 N531FXCitation X Parts LLC · Liberty, NCBuilt 2007 · S/N 20150 N532FXCitation X Parts LLC · Liberty, NCBuilt 2007 · S/N 20154 N533XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20045 N534FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20161 N534XJTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTBuilt 2013 · S/N 20406 N535FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20167 N535XJU S Bank Na · Marshall, MNS/N 20137 N536FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20171 N536XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 20036 N537FXDawsco US Corp · Cleveland, OHBuilt 2024 · S/N 21011 N537XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 20213

Back to AD 2017-17-13