Skip to content

Registered aircraft · 90

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

N47086Harrington Brian G · Boyne City, MIS/N V21590 N503JPPatterson James F · Spearfish, SDBuilt 1990 · S/N 2289 N5276JAlderman Steve K · Fort Pierce, FLBuilt 1984 · S/N 6465B61 N534CSPluto 47 Inc · Wilmington, DEBuilt 1993 · S/N 534 N5391MAcklam David · Yelm, WABuilt 1989 · S/N 7097 N541SXCuster Byron · Manassas Park, VAS/N 541 N54ASNeils James L · Hauser, IDBuilt 1978 · S/N B-769 N555WXBaker Wesley D · Las Cruces, NMS/N W0215 N564DCCash Danny L · Chillicothe, OHBuilt 2012 · S/N 0380 N596EWWells Carolyn B · Whitefish, MTBuilt 2014 · S/N 30 N618DKWillis Drake E · Young America, MNBuilt 2017 · S/N HO-1194 N638SDDale John E · Newberry, FLBuilt 2000 · S/N SK127 N63PJWood Paul S · Lawton, OKS/N 2452 N64ASNeils John J · Hauser, IDBuilt 1977 · S/N B-760 N665RSStuart George G · Maceo, KYBuilt 2007 · S/N 779 N68DDDugas David J · Orange, MABuilt 2000 · S/N 2746 N701EFWildlife Aviation Group Inc · Senoia, GABuilt 2007 · S/N 1223 N7044EHale Bradley A · La Palma, CABuilt 1989 · S/N 1127 N7192FMason Benny F · Effingham, ILBuilt 2015 · S/N 042413-1248 N722MKnight Eugene S · Hickory, MSBuilt 2013 · S/N 001 N729KSIida Justin S · Bluffton, INS/N KPS-1 N757MXRogers Clay G · Hodgenville, KYBuilt 2014 · S/N CC332 N760TRRondeau Daniel M · Sheboygan, WIBuilt 2017 · S/N KR28317 N77VPLongpoint Solutions LLC · Houston, TXS/N 001 N804JRDemeter Dennis J · Gladwin, MIBuilt 2009 · S/N 08031511 N80771Cox Thomas A · Franksville, WIBuilt 1983 · S/N BR16500 N81CCCurtis David W · Watertown, NYBuilt 1996 · S/N 537 N8495NHuerta Edward R · Silver City, NMS/N 470-34-0393-2 N85BJKidd Robert L · Logan, UTS/N 2438 N86JTCabrera Monique E · Ontario, CABuilt 2000 · S/N 2607 Q-2 N86KLParker Anthony C · New Ipswich, NHS/N 2613 N86TBBryant Timothy P · Port Matilda, PABuilt 1988 · S/N 2325 N87826Paffendorf George W · Hackettstown, NJS/N 1 N88GHHess Dale G · Hurricane, UTBuilt 1979 · S/N GH-1 N89TRRogers Terre F · Molalla, ORBuilt 2011 · S/N 089 N8VWGroenewegen Bruce C · Snohomish, WABuilt 1982 · S/N 1119 N931BEHale Bradley A · La Palma, CABuilt 1994 · S/N 474 N93BMMarteney Bruce C · San Dimas, CABuilt 1993 · S/N 7393 N95LRBlue Skies Aviators LLC · Kingwood, TXBuilt 1985 · S/N 2111 N999DLIrwin Aviation LLC · Indianapolis, INBuilt 1982 · S/N 122333

Back to Revmaster 2100