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.

N350JRKatz Aviation Holdings LLC · Pompano Beach, FLBuilt 2020 · S/N 20856 N350KHAmerican Builders & Contractors Supply Co Inc · Beloit, WIBuilt 2020 · S/N 20845 N350KMCarolina Air Transfer II LLC · Alpharetta, GABuilt 2014 · S/N 20505 N350KRMmr West LLC · Salem, ORBuilt 2019 · S/N 20808 N350LTDohertys Toys Second LLC · Lakeland, FLBuilt 2017 · S/N 20685 N350LY350 Lear Yankee Partners LLC · Chesterfield, MOBuilt 2019 · S/N 20820 N350MBRockwell Collins Leasing LLC · Cedar Rapids, IABuilt 2014 · S/N 20531 N350NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20794 N350PDBrighid Air LLC · Farmingdale, NYBuilt 2016 · S/N 20611 N350PHPamplemousse Corp · Wilmington, DEBuilt 2015 · S/N 20571 N350PRMmr West LLC · Salem, ORBuilt 2018 · S/N 20779 N350RMBeyond Ventures LLC · Ellicott City, MDBuilt 2015 · S/N 20605 N350RXRamsey Craig · Santa Rosa, CABuilt 2015 · S/N 20582 N350TNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20778 N350TTN350tt LLC · Dover, DEBuilt 2026 · S/N 21120 N350VJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20569 N350XADodson International Parts Inc · Rantoul, KSBuilt 2018 · S/N 20749 N350XJRegistered aircraftBuilt 2017 · S/N 20677 N350XKRegistered aircraftBuilt 2019 · S/N 20816 N350XXPete Mitchell Aviation LLC · Plantation, FLBuilt 2004 · S/N 20019 N351CTNorth Dakota Associates LLC · Spartanburg, SCS/N 20770 N351ECE C Aviation Services Inc · Zeeland, MIBuilt 2016 · S/N 20625 N351JLLink Snacks Inc · Hayward, WIBuilt 2018 · S/N 20775 N351SDDynamic Aviation LLC · Fort Wayne, INBuilt 2024 · S/N 21020 N351TSCmfg Life Insurance Co · Madison, WIBuilt 2018 · S/N 20735 N351VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20573 N352ECE C Aviation Services Inc · Zeeland, MIBuilt 2025 · S/N 21072 N352SDDynamic Aviation LLC · Fort Wayne, INS/N 21021 N352WWorthington Enterprises Inc · Columbus, OHS/N 20872 N353PCQuantum Aviation LLC · Tampa, FLBuilt 2005 · S/N 20053 N354ASSoave Aviation LLC · Plymouth, MIBuilt 2022 · S/N 20914 N354WGAutomatic Press LLC · Horseshoe Bay, TXBuilt 2012 · S/N 20354 N355ZBZimmer Biomet Leasing LLC · Warsaw, INBuilt 2025 · S/N 21083 N356MLAviation Travel Ventures LLC · Melbourne, FLBuilt 2005 · S/N 20075 N356VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20546 N357CZCz Equipment LLC · Hollywood, FLBuilt 2015 · S/N 20597 N357KGN357kg LLC · Bluffton, SCBuilt 2003 · S/N 20012 N357TWLazer Aviation LLC · Orange Park, FLBuilt 2011 · S/N 20314 N357VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20550 N358MHIci Aviation Leasing LLC · Daytona Beach, FLBuilt 2017 · S/N 20680 N358VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 20890 N359VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 20904 N35FEFederal Express Leasing Corp · Memphis, TNBuilt 2013 · S/N 20408 N360LRegistered aircraftBuilt 2016 · S/N 20635 N360VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 20907 N361JLLink Snacks Inc · Hayward, WIBuilt 2023 · S/N 20944 N361VJRegistered aircraftN-number assigned (import), not yet registeredS/N 21146 N362JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20249 N362LRegistered aircraftBuilt 2010 · S/N 20291 N365AVN365av LLC · Chandler, AZBuilt 2017 · S/N 20669

Back to AD 2017-17-13