Skip to content

Registered aircraft · 9

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 ('33723')
  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 ('33723')
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.

N1892CJohnson Troy A · Greenfield, MOS/N 0194W0460 N2485ZHiatt Philip D · Marion, NCBuilt 1996 · S/N 001 N3028UMullins Randy L · Connersville, INBuilt 1993 · S/N CH219-0593 N328BJOloughlin Daniel W · Billings, MTBuilt 2001 · S/N CH2 0291 CW0641 N546EBurkhardt Kalan M · Tulsa, OKS/N CH21091BK0741 N6230XDeane George I · Merced, CABuilt 2001 · S/N M3-025 N7062RPleasants Hugh B III · Cartersville, VABuilt 1986 · S/N F1035 N8061RGordon Benny B · Columbia City, INBuilt 2005 · S/N RLH20014169 N830AFRieck Brian M · Junction, TXBuilt 1990 · S/N 001

Back to Hirth 2703