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.

N582TSSmith Terry W · Jackson, GAS/N KGM1952 N582UTPridmore Sally J · Fairfield, IDFirst renewal noticeBuilt 2002 · S/N 2137 N582VCCozzolino Aerosports LLC · Indianapolis, INBuilt 2004 · S/N 582-814 N582WSSmith Wesley R · Springfield, ILBuilt 2002 · S/N 5-8-9-0005 N582YARauseo David S · Canterbury, NHS/N 582-991 N583WSToomey Lyn R · Londonderry, NHBuilt 1998 · S/N 3071 N5877WGreen Evan R · Calabasas, CABuilt 2003 · S/N 16336 N597QDSportsman Aviation LLC · Winter, WIBuilt 2015 · S/N 106 N59WTRobinson Darrin P · Leicester, NCBuilt 2003 · S/N 613 N6005KHiller Randy L · Virgin, UTBuilt 2003 · S/N A152 PEG N6044AChristopher K Lobdell · Kokomo, INBuilt 2006 · S/N 16429 N6044BShell James R · Bremen, INBuilt 2003 · S/N 16361 N6048FRose Ralph A · Grand Lake, COS/N 121727 N6048MPolec Don J · Buckingham, PABuilt 2006 · S/N A571 B151 N6049CHartlaub Kirk · Halifax, PAS/N G003 N60544Lee Dwight E · Macon, MSBuilt 2006 · S/N 010 N6062TMansel Scott J · Hickory Flat, MSBuilt 2000 · S/N 1B0159 N61048Kelly John M · Wichita Falls, TXBuilt 2006 · S/N A412PEG N61090Anthony Brian · Birch Run, MIBuilt 2007 · S/N CH2-0806-2758 N6109DGreenwall Donald W · Pocahontas, ILBuilt 1992 · S/N 1092312 N610BMMcdaniel Robert L · Columbia, ILBuilt 2004 · S/N 16418 N610KWelch Robert A · Greenfield, INBuilt 2007 · S/N K1936G N610RPHancock Bobby L · Wadesboro, NCS/N 099 N6117TCole William H · Garner, NCS/N IPP5292 N61203Morrow Ray A · Baton Rouge, LAS/N 726 N6123RPhillips Donald G · Argonia, KSBuilt 2007 · S/N IPP7-355 N6124WTew Stephaney S · Bossier City, LAS/N 0043 N6140QBuli Dylan · Boulder, COBuilt 2007 · S/N 3959 N61415Ashby Robert D · Collinston, UTBuilt 1995 · S/N 4655878 N6143AJohnson Alvin · Fredonia, AZS/N 4391 N61446Dibb Trent M · Brown Deer, WIBuilt 2003 · S/N A130PEG N6144SGiezen Kirk W · Parker, COBuilt 1993 · S/N 4015151 N61456Lombard Robert A · Riverdale, MIS/N 16504 N6146SClement Denis N · La Place, LABuilt 2007 · S/N A231PEG N61472Daar Bradley J · Clinton, CTBuilt 2001 · S/N T01073 N6152LFunk Bruce C · Clawson, UTBuilt 2000 · S/N A148POW N6153TWilson John M · Springdield, OHBuilt 2000 · S/N 1B0133 N6155TBoese Delroy L Jr · Livingston, MTBuilt 1999 · S/N 4830 N61569Lange Keith J · Ocala, FLS/N AB123T N61572Rhynearson John E · Hobart, INBuilt 2006 · S/N A 422 PEG N61638Walbert Allin J · Walkerton, INBuilt 1997 · S/N E049JS N6164APrater Robert A · Cicero, INS/N 3653 N61669Hamby Scott · Custer, SDBuilt 1992 · S/N 2746104 N6166SGlass Gregory A · Emerald, WIBuilt 2004 · S/N 12A-1 N61679Robles Omar A · Mexia, TXBuilt 2002 · S/N A-222-PEG N6167DThompson Tyler J · Church Hill, MDS/N 021 N6168UGustin Steven L · Dickens, IABuilt 2000 · S/N 2C0360 N6171DFillipi Larry W · Anthon, IABuilt 2007 · S/N A448PEG N6175YPaysse Robert H · Grapeview, WABuilt 2007 · S/N IPP3 182 N6177FPritchett David B · Anderson, INBuilt 2002 · S/N 16253

Back to Rotax 582SER