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.

N571FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 20536 N572FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 20521 N573FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20564 N574FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20567 N575FDEcho Acquisitions LLC · Dover, DEBuilt 2004 · S/N 20023 N575FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20578 N576FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20585 N577FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 20865 N57810Palmer Square Capital Management LLC · Mission Woods, KSBuilt 2024 · S/N 21015 N578FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20601 N578XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20078 N579FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 20647 N580FXWheels Up Partners LLC · New York, NYBuilt 2016 · S/N 20652 N581FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 20657 N582FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20701 N583FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20703 N584FXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 20705 N585AXCentury Mold Holdings LLC · Rochester, NYBuilt 2007 · S/N 20184 N585FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20707 N586ALRegistered aircraftBuilt 2015 · S/N 20586 N586FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20710 N587FARegistered aircraftBuilt 2015 · S/N 20587 N587FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20712 N588FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20714 N589FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 20757 N58HAAcrisure Aircraft N58ha LLC · New York, NYBuilt 2007 · S/N 20146 N58LCAtlantic Excel LLC · San Marcos, CABuilt 2007 · S/N 20163 N590CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20857 N590FXFlexjet LLC · Cleveland, OHS/N 20761 N590MCRegistered aircraftBuilt 2004 · S/N 20027 N591FXFlexjet LLC · Cleveland, OHS/N 20764 N592FXFlexjet LLC · Cleveland, OHS/N 20767 N593FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20819 N594FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20821 N595CBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20326 N595FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20825 N596FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20827 N596LCHangar 39 LLC · Elkhart, INBuilt 2016 · S/N 20596 N597FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20831 N598FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 20864 N599FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20802 N599JFLearjet Inc · Wichita, KSBuilt 2016 · S/N 20632 N59KGRegistered aircraftBuilt 2013 · S/N 20393 N5LAir Sansone LLC · Wilmington, DEBuilt 2006 · S/N 20101 N600CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20191 N603GPN603gp LLC · Dover, DEBuilt 2016 · S/N 20660 N605HPPalmetto Express Company LLC · Wilmington, DEBuilt 2020 · S/N 20847 N606RPSydes Aviation LLC · Jacksonville, NCBuilt 2010 · S/N 20309 N607GJGabinoah LLC · Miami Beach, FLBuilt 2013 · S/N 20414 N608ABCl350 20589 LLC · Missoula, MTBuilt 2015 · S/N 20589

Back to AD 2017-17-13