Skip to content

Registered aircraft · 72

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

N103HVLedoux Joseph P · Bridge City, TXBuilt 2001 · S/N 021 N109LTAdams Robert E · Sullivan, MOBuilt 1997 · S/N CH2-1313-422 N114TTPyle Lester D · Kingfisher, OKBuilt 1995 · S/N T92503COHK0040 N142CGMeadows Larry W · Wimauma, FLBuilt 1990 · S/N 90131 N142MBFordahl Craig A · Loretto, MNBuilt 2007 · S/N 001 N181DLOpperman Robert Michael · Peoria, AZBuilt 2013 · S/N 0913-001-CH1 N181MMccroskey Danny D · Ward, ARBuilt 1992 · S/N 0392106 N194PGMcgee Michael J · Summerville, SCBuilt 1993 · S/N 1993P N19636English John Day · Richmond, CABuilt 1993 · S/N CH20893CW1011 N1992CGray Shane C · Interlochen, MIS/N 001 N203MLewis Landon J · Hope, NDBuilt 2015 · S/N SPRINT 11 242 N212NMapes Joseph S · Stevens Point, WIBuilt 2007 · S/N 001 N217ABJohnson Kevin W · Hardwood, MIBuilt 1996 · S/N 1008 N2518WHeidger Roy E · Hortonville, WIBuilt 1997 · S/N HHF 5848 N2558NGard George A · Irving, NYBuilt 2007 · S/N 001 N2574WWestfield Technical Academy · Westfield, MABuilt 2002 · S/N 2002-20 N2639THudgins John M · Era, TXBuilt 1995 · S/N 0007 N2827AOsborn John L · Goodwine, ILBuilt 1988 · S/N FP-404-041989 N2844CRegistration Pending · Greenville, MIRegistration pendingS/N CH2-0205-CW-2591 N29GKMcentee Richard J · Mount Dora, FLBuilt 2001 · S/N 10GDK N301CDPlatt Jerry R · Marysville, WABuilt 1984 · S/N PH 00186 N3079HHartsoe Robert Anthony · Kernersville, NCS/N 5847 N3094SLeinbach Lamar M · Curtiss, WIBuilt 1990 · S/N XYZ2 N328BKBlythe Brian K · Macomb, ILBuilt 2002 · S/N CH2-0102-2181 N330TMRegistered aircraftBuilt 2017 · S/N 28496 N3504UJenkins Michael L · Tonopah, AZBuilt 1993 · S/N H-SSA-939-R503-TRL N361STEms Kenneth R · Biloxi, MSBuilt 1990 · S/N 0189-0388 N381ASSmith Nathan A · Selbyville, DEBuilt 1984 · S/N H-SSC-426-503-TRI N388DGrunloh Daniel J · Loda, ILBuilt 1998 · S/N A02180-2198 N39WAAngolia Anthony Wayne · Warsaw, VABuilt 2004 · S/N 039 N4368JDillon Stephen F · Webster, TXBuilt 2006 · S/N T0229 N457MAAddis Michael T · Tucson, AZBuilt 1997 · S/N 0022 N500ZCBell Timothy W · Scotland Neck, NCBuilt 2002 · S/N CH2-0700-1985 N5026JFoppe Dean D · Ottawa, OHBuilt 2015 · S/N CH20887B0267 N503BJSkyraider N503bj LLC · Chesaning, MIBuilt 2001 · S/N 029 N503RLFoothills Aviation LLC · Buhl, IDBuilt 2007 · S/N H-SSC-933-503-TRI N5066ZJones Donald E · Hollandale, MNBuilt 1990 · S/N 271 N5067FLein James N · Cambridge, WIBuilt 1997 · S/N 001 N5084JCurless Glen M · Janesville, WIBuilt 2001 · S/N SR2CL-2647 N5085RNicolai Eric A · Garretson, SDS/N 000830 N5128MCoyle Ralph V · Clarkston, WABuilt 2003 · S/N 001 N51351Adams Michael C · Saint Louis, MOBuilt 2000 · S/N 001 N5161GGetz Jeremy E · Hellertown, PAS/N 112762 N519WDStenger Brian · Big Horn, WYBuilt 1987 · S/N 519 N5202PJorns Bernard C · Millstadt, ILS/N CP530 N5684LWright Ronald E · Overland, MOBuilt 2004 · S/N 3 N592JEEllebracht Gerald H · Waterloo, ILBuilt 2007 · S/N FS7-2-089 N594TCChevres Rios Jose Antonio · Dorado, PRBuilt 1995 · S/N 5690 N6003NMorris Thomas J · Big Rapids, MIBuilt 1998 · S/N 1859965 N6037NEaston Michael A · North Pole, AKBuilt 2000 · S/N 503-620

Back to Rotax 503DCSI