Skip to content

Registered aircraft · 174

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

N81973Sorensen Danny S · Bountiful, UTBuilt 2008 · S/N 24601-001 N822ALTradecraft Flying Service LLC · Wellington, FLBuilt 1982 · S/N 822202 N8252Glaser Scott T · Rosamond, CABuilt 1982 · S/N 822903 N82623Lamprecht Marinus · El Granada, CABuilt 1982 · S/N 822310 N84YKHamel Stephen M · Hudson, WIBuilt 1984 · S/N 844611 N8519QDaus Jeffrey C · Louisville, KYS/N 842707 N8712Amsrud Eric M · Marble Hill, GABuilt 1986 · S/N 866306 N888YKLon Brothers Aviation LLC · Miami, FLS/N 9511903 N88YKRed Star Warbirds LLC · Las Vegas, NVBuilt 1988 · S/N 888705 N894ZSmith Jeremy B · Jemison, ALBuilt 1988 · S/N 889214 N9073ERegistration Pending · Phoenix, AZRegistration pendingBuilt 1986 · S/N 867209 N90SMGolden Christopher A · Cartersville, GABuilt 1991 · S/N 9111508 N90YKJpm Holdings Nv LLC · Carson City, NVBuilt 1990 · S/N 9010808 N9102EBluff Raymond E IV · El Cajon, CABuilt 1982 · S/N 822301 N910TCBeezhold Terence J · Lake Stevens, WABuilt 1975 · S/N 5200808 N9110MMurray Amanda K · Falmouth, MEBuilt 1986 · S/N 866112 N917SPN63e LLC · Fallon, NVBuilt 1995 · S/N 02-03 N918TMMitchell Robert A K · West End, NCBuilt 1997 · S/N 7200713 N9218TMcdonald Jake V · Bowling Green, MOBuilt 1982 · S/N 22202034096 N922TPHuston Charles D · Austin, TXBuilt 2008 · S/N 188 N926MK-Factor Aircraft Corp · Jupiter, FLBuilt 1994 · S/N 05-01 N92864Pope Garry L · Oakwood, GABuilt 1968 · S/N 1632018 N92GGTen G LLC · Waddell, AZBuilt 1980 · S/N 801610 N9859Affordable Casket Outlet LLC · Honolulu, HIBuilt 1984 · S/N 844304

Back to Vedeneyev M14P