Skip to content

Registered aircraft · 578

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

N92FPShipway Raymond W · Santa Rosa, CABuilt 2017 · S/N RS003 N9303BSchultz Bradley J · Longmont, COBuilt 2001 · S/N 5437470 N9326XLove William E · Round Top, TXBuilt 2001 · S/N SR7XL-2649 N93370Junkerman Herman L · Monroeville, NJBuilt 2002 · S/N A 329 POW N93375Jackson Matthew A · Sterling, AKBuilt 2002 · S/N 2782XL N9338WHamilton Scott B · Turon, KSBuilt 2000 · S/N A28POW N9348VLangr Kenneth · Rochester, MNBuilt 2003 · S/N 2891 N9357NNewman Robert H · Fort Davis, TXBuilt 2002 · S/N 001 N9375RFlight Texas LLC · Granite Shoals, TXBuilt 2007 · S/N 582-703 N9382RBroers John B · Houston, MNBuilt 2007 · S/N A449PEG N93998Boone Dennis W · Damascus, GABuilt 2001 · S/N A195POW N94326Salary Kerry L · Jefferson, GAFirst renewal noticeBuilt 1990 · S/N 07980152 N94465Hanson Todd A · Roseville, CABuilt 2001 · S/N IPP1-017 N94495Mansfield Harold R · Fenton, MOBuilt 1999 · S/N 99-2200 N9451PWilson Harold A · Louisiana, MOBuilt 2001 · S/N A237POW N94526Clancy Kevin R · Utica, ILS/N 6082 N94572Trombley Roger W · Ellenburg Center, NYBuilt 1996 · S/N 07582 N9458MReyner Steven W · Hannibal, NYBuilt 2001 · S/N 000556 N94657Johnson Ward C · Fredericksburg, TXBuilt 2000 · S/N 1B0103 N94705Leasman Tasewell E · San Antonio, TXBuilt 2002 · S/N A-067-PEG N94754Sharpe-Gregg Patricia S · Libertyville, ILBuilt 2001 · S/N 2C0333 N9475GBorths Jamie C · Kenosha, WIBuilt 2005 · S/N 4C0642 N9475VTharp Joseph M · Lonedell, MOBuilt 2003 · S/N 4C0592 N95509Ruggles Richard · Redding, CTBuilt 2006 · S/N IPP6-320 N959JCCraparo John S · Georgetown, TXBuilt 2012 · S/N A497PEG N971DGRohrer Richard C · Bridgewater, VABuilt 2001 · S/N 6180 N97999Cunningham Richard · Lakeside, CABuilt 2010 · S/N 0245 N9LMNeilsen Edward M · Beaver, UTBuilt 2003 · S/N SPIRITDE-2895

Back to Rotax 582DCDI