Skip to content

Registered aircraft · 1,193

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

N46HKSimmons James M · Lake Placid, FLBuilt 2018 · S/N HAII-330TRI N470AFRamsey Samuel Lee · Mount Vernon, MOBuilt 2003 · S/N 975-B N471EADaytona Consulting Inc · Jacksonville, FLBuilt 2012 · S/N 03071797 N471GTWilson Randall L · Pasadena, TXBuilt 2001 · S/N GT2801471 N471PJXl Flying Inc · Fort Walton Beach, FLS/N US027777 N471RLWells Robert · West Union, ILBuilt 2015 · S/N 0812ELSA58201 N4735FFatula Robert A · Deerfield, OHBuilt 2005 · S/N IPP5-315 N473PWWinkleblack Patrick C · Grand Rapids, MNS/N 1085D N474AFSmith Gary L · Redfield, IABuilt 1998 · S/N 55 386403 N474LLaney Rebecca A · New London, NCS/N 0592215 N476PNelson Bradley J · Wolverton, MNBuilt 1997 · S/N 0697430 N477ZBisig John A · Elba, NYBuilt 1999 · S/N 99-2310 SR7XL N4809AGirard Louis W · Schulenburg, TXBuilt 2002 · S/N 131014 N4813EClark Dean A · Lidgerwood, NDBuilt 2002 · S/N 16998 N4819FNededog Michael J · Fort Collins, COBuilt 2002 · S/N 582-671 N4828WWilliams Jamey P · Thompson Falls, MTBuilt 1997 · S/N 1635-25R7 N4829DWilliams Jim W · Thompson Falls, MTBuilt 2000 · S/N JJJ1 N4846AFerguson Douglas B · Boulder Creek, CABuilt 2006 · S/N DT 333 N4857FShuck David B · Denton, TXS/N 042969 N4864APrestenbach Kyle A · Vacherie, LABuilt 2007 · S/N AM 02582-3.47-14 N4866Learn To Fly LLC · Prospect, KYBuilt 2004 · S/N SPORT 2S 0078 N4867AAllbritton Kristian J · Austin, TXBuilt 1995 · S/N 001 N486DRTaylor Fred J · Hudson, FLBuilt 2016 · S/N 0812-485 N488AStier Steven T · Hahira, GAFirst renewal noticeBuilt 2007 · S/N A176POW N4900TKopa Bryan · Denton, NCBuilt 1997 · S/N 3838 N4904TLafler Construction Inc · Middlesex, NYBuilt 1999 · S/N 99-2300-SR7XL N492DGCarrier Steven · Albany, NHBuilt 2013 · S/N IPP13-415 N494EMMicah 68 LLC · Mobile, ALBuilt 2013 · S/N 052013 N495JWBowe Walter C Trustee · Sonoma, CABuilt 1993 · S/N 1162 N5005XFontes Bruce G · North Dartmouth, MABuilt 2001 · S/N 1B0153 N50093Palesh Christopher D · Port Orange, FLBuilt 1994 · S/N 00671 N500QDPetersen Ryan C · Carmichael, CABuilt 2014 · S/N 0294 N50152Meigs Craig D · Jasper, ALS/N 2C0315 N50241Dowd Danny D · Ithaca, MIBuilt 2003 · S/N IPP3-159 N502FPCollier Tony · Grayson, KYBuilt 2014 · S/N IPP14-417 N50309Teems Arthur R · Port Saint Lucie, FLBuilt 1999 · S/N 001 N50370Finchum Daniel · New Market, TNBuilt 2004 · S/N 16381 N50489Osipchuk Ruvim · Delta Junction, AKS/N 582-570 N5052CLester Gordon W · Corpus Christi, TXBuilt 2001 · S/N A220POW N505KKuharske Jeffrey H · Groveland, FLBuilt 2015 · S/N S 115 N505PSZook David R · Gap, PAS/N 4554 N5065QGarber Chet I · Ohatchee, ALBuilt 2006 · S/N 3C0526 N50692Cantrell Timothy A · Murray, KYBuilt 1995 · S/N 582-181 N5075JGammel Scott A · Pineville, LABuilt 2004 · S/N A 263 PEG N5076FRitchie Todd R · Bandera, TXBuilt 1997 · S/N 3790 N5079FChicco Miguel E · Burbank, CAS/N 0146 N5079JCallahan Amy F · Plymouth, NHS/N IPP2-126 N50801Gregory David A · Westmoreland, TNBuilt 2007 · S/N 4510 N50802Campbell Timothy B · Saint John, INS/N A021PEG N5080SWooten Joseph E · Jonesboro, ARBuilt 1994 · S/N 390292

Back to Rotax 582SER