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.

N5081JPatten Ben P · Broadus, MTBuilt 2005 · S/N 16439 N5084YMeyers Steven C · Holmen, WIBuilt 2007 · S/N 1B0196 N5091FColosky Kelly A · Flushing, MIBuilt 2006 · S/N 1C0209 N5092DBachmeier Taylor P · Granville, NDS/N 0065 N5092RShenhav Alon · Rye Brook, NYS/N 214 N509ZRReynolds Jarrod N · Lipan, TXBuilt 1997 · S/N 3605 N51061Graham Joseph M · Joplin, MOBuilt 2002 · S/N A 063 PEG N51073Flight Texas LLC · Granite Shoals, TXS/N 582-880 N5107USmith Randall · Quitman, GABuilt 2009 · S/N 491955 N51210Osborn Robert G · Coffeyville, KSBuilt 2002 · S/N A-015PEG N5132ZHowell Jeannet D · Orlando, FLBuilt 2006 · S/N HD 05138 M N5133FCarlson Mark A · Conway, SCBuilt 2004 · S/N A-250-PEG N5134SObad Saleh A · Howe, INS/N 2005041 N51357Registration Pending · Chapin, SCRegistration pendingBuilt 2000 · S/N 11SC5011 N51360Xl Flying Inc · Fort Walton Beach, FLS/N 29644 N51375Crabtree Myrl R · Garrison, TXBuilt 2003 · S/N D606 N5138JGonzalez Jaime Trustee · Ramona, CABuilt 2002 · S/N T99045 N5140LShadoan Peter D · Sumter, SCBuilt 2007 · S/N 3C0409 N51465Journett Luis R · Orlando, FLBuilt 2007 · S/N 001 N5148MRegistration Pending · Polk City, FLRegistration pendingS/N TT0B01 N514GSShockley Thomas J · Caledonia, MSBuilt 2003 · S/N SKR0807203 N51527Bird Michael W · Gearhart, ORBuilt 2003 · S/N SPIRIT XL 2896 N5152GHoward Michael D · Groveland, FLBuilt 2001 · S/N EDGEX582-695 N51556Harvey Bruce A · Chetek, WIBuilt 2004 · S/N 0062 N51646Hirsch Douglas R · Pelham, NHBuilt 1999 · S/N T99018 N5164ASchrock Abraham A · Homerville, OHBuilt 2004 · S/N 0066 N5165EKocot Michael T · Myrtle Beach, SCBuilt 2002 · S/N Y011270-ANC N5168MStroup John P · Falls Church, VABuilt 1993 · S/N 0692241 N5171XFuller Charles · Fort Smith, ARS/N 1B0125 N51766Tran Derek K · Happy Valley, ORBuilt 2002 · S/N 123069 N5178XHuynh Van T · Ridgefield, WABuilt 2003 · S/N 121741 N51837Riffe Thomas W · Larkspur, COS/N 002 N51EJQuicksilver Of Ohio LLC · Wooster, OHBuilt 2015 · S/N 0702 N5219AHarrelson Paul E · Wichita Falls, TXBuilt 2007 · S/N A445 PEG N522RWPapp Daniel R · Pinehurst, NCBuilt 2014 · S/N 0076 N523HTMiller Guy G · Russellville, KYBuilt 2015 · S/N 7-4028 N525KPearson William C · Lenoir, NCBuilt 2001 · S/N 582-624 N52631Gifford Edward C · Manhattan, KSBuilt 2006 · S/N A181PEG N52672Mercer Steven L · Kearney, NEBuilt 2000 · S/N 4861 N5333AHollingsworth Martin L · Delaware, OHBuilt 2001 · S/N SR5XP2749 N5358ZBynum Bruce W · Katy, TXBuilt 2010 · S/N P582E40201 N535ZWOwsley Quentin M · Fortuna, CABuilt 2016 · S/N 264 N536MCCorrigan Michael S · Cedar Grove, TNBuilt 2003 · S/N 6217 N537MPWeichert Eric S · Janesville, MNBuilt 2014 · S/N CH2-1213-LSS-L65-0251 N538DRPechacek Zdenek H · Hovland, MNBuilt 2003 · S/N 2879 N543JHMinakes Carolyn J · Killen, ALS/N 16534 N543TUJorgensen Ronald G · Touchet, WABuilt 2000 · S/N DISC.-21 N544BCMolano Gonzalo A · Marana, AZBuilt 1993 · S/N 1092297 N5454CBrooks Larry S · Dawsonville, GABuilt 1992 · S/N 9207-3414 N545HPPerico Herbert · Poway, CABuilt 2003 · S/N AR-2555-5

Back to Rotax 582SER