Skip to content

Mattituck TMX O-320

Registered aircraft · 17

Aircraft with this engine 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 engine_model_code IN ('59601')
  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 engine_model_code IN ('59601')
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.

N113SQPettus Gary A · Fort Mill, SCBuilt 2011 · S/N 91065 N13PLDye Paul F · Dayton, NVBuilt 2011 · S/N 11425 N248MRGuimont William P · Lynnwood, WAS/N 5232 N334ABBerges Duncan L · Mt Juliet, TNS/N 90784 N413RVMcinnis David F · Raleigh, NCBuilt 2016 · S/N 90365 N4822CBenning Tanya M · Cedar Park, TXBuilt 2007 · S/N 91070 N512JMNye James F · Howell, MIBuilt 2013 · S/N 91787 N5429AHoffman Wilson H · Oakland, CABuilt 2008 · S/N 91212 N58AVVick Alan J · Cottage Grove, WIBuilt 2023 · S/N 91728 N65KWRv-6a Flyers LLC · San Dimas, CABuilt 2006 · S/N 90807 N800BMWard Scott · Wills Point, TXBuilt 2008 · S/N 90841 N831JVYeo Stuart · Guthrie, OKBuilt 2008 · S/N 91066 N83KUMacy Johnathan I · Virginia Beach, VABuilt 2008 · S/N 5731 N857TMWalter John P · College Station, TXBuilt 2007 · S/N 90857 N949WGWalkowiak William · Los Lunas, NMBuilt 2007 · S/N 90698 N957JLBird Brian A · Hutchinson, KSBuilt 2014 · S/N RHS-1 N984AWWieder Alan J · Eugene, ORBuilt 2013 · S/N 91611

Back to Mattituck TMX O-320