Skip to content

Registered aircraft · 402

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2076814')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2076814')
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.

N532JM31 Pine Street LLC · Moorpark, CABuilt 2023 · S/N 680A0370 N532QSRegistered aircraftBuilt 2017 · S/N 680A0073 N533QSRegistered aircraftBuilt 2017 · S/N 680A0074 N534QSRegistered aircraftBuilt 2022 · S/N 680A0315 N535QSRegistered aircraftBuilt 2017 · S/N 680A0078 N536QSRegistered aircraftBuilt 2017 · S/N 680A0079 N537QSRegistered aircraftBuilt 2017 · S/N 680A0087 N538QSRegistered aircraftBuilt 2017 · S/N 680A0081 N539QSRegistered aircraftBuilt 2017 · S/N 680A0082 N540QSRegistered aircraftBuilt 2017 · S/N 680A0083 N541QSRegistered aircraftBuilt 2017 · S/N 680A0084 N542QSRegistered aircraftBuilt 2017 · S/N 680A0091 N543QSRegistered aircraftBuilt 2017 · S/N 680A0092 N544QSRegistered aircraftBuilt 2017 · S/N 680A0093 N545QSRegistered aircraftBuilt 2017 · S/N 680A0095 N547QSRegistered aircraftBuilt 2017 · S/N 680A0094 N548QSRegistered aircraftBuilt 2017 · S/N 680A0105 N549QSRegistered aircraftBuilt 2017 · S/N 680A0098 N550LVPronto LLC · Oklahoma City, OKBuilt 2017 · S/N 680A0066 N550QSRegistered aircraftBuilt 2018 · S/N 680A0150 N551QSRegistered aircraftBuilt 2018 · S/N 680A0151 N552QSRegistered aircraftS/N 680A0287 N553QSRegistered aircraftBuilt 2022 · S/N 680A0296 N554CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 2021 · S/N 680A0285 N554QSRegistered aircraftBuilt 2022 · S/N 680A0297 N558RXBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 680A0033 N559QSRegistered aircraftBuilt 2017 · S/N 680A0090 N560QSRegistered aircraftBuilt 2017 · S/N 680A0110 N561QSRegistered aircraftBuilt 2017 · S/N 680A0111 N562QSRegistered aircraftBuilt 2017 · S/N 680A0112 N563QSRegistered aircraftBuilt 2017 · S/N 680A0113 N564QSRegistered aircraftBuilt 2017 · S/N 680A0114 N567QSRegistered aircraftBuilt 2018 · S/N 680A0121 N569QSRegistered aircraftBuilt 2018 · S/N 680A0122 N56TEThumb Aviation LLC · Bad Axe, MIBuilt 2023 · S/N 680A0367 N570QSRegistered aircraftBuilt 2018 · S/N 680A0125 N571QSRegistered aircraftBuilt 2018 · S/N 680A0126 N572QSRegistered aircraftBuilt 2018 · S/N 680A0133 N578QSRegistered aircraftBuilt 2018 · S/N 680A0135 N581QSRegistered aircraftBuilt 2018 · S/N 680A0137 N582QSRegistered aircraftBuilt 2018 · S/N 680A0138 N584QSRegistered aircraftBuilt 2018 · S/N 680A0139 N585QSRegistered aircraftBuilt 2018 · S/N 680A0141 N586QSRegistered aircraftBuilt 2018 · S/N 680A0142 N58WEBoomer Air LLC · Conway, ARBuilt 2016 · S/N 680A0025 N591QSRegistered aircraftBuilt 2018 · S/N 680A0144 N593QSRegistered aircraftBuilt 2018 · S/N 680A0145 N595AGGrowmark Inc · Bloomington, ILBuilt 2018 · S/N 680A0169 N595QSRegistered aircraftBuilt 2018 · S/N 680A0146 N595RHTextron Aviation Inc · Wichita, KSS/N 680A0498

Back to Textron 680A