Skip to content

Registered aircraft · 135

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

N70660Annable John Jay · Torrance, CABuilt 1994 · S/N 103094 N7390FKing Michael C · Cherry Valley, CABuilt 2017 · S/N 001 N7531LNates Timothy A · Hollywood, SCS/N 2451P N75470Mathis Brian J · Colgate, WIBuilt 2007 · S/N 210 N75476Williams Stephen L · Canton, SDBuilt 2007 · S/N 101579 N75625Frantz Duane R DBA · Tyaskin, MDFirst renewal noticeBuilt 2003 · S/N 095 N780MAWilson Kenny W · Pleasant View, UTBuilt 2010 · S/N 0704-0788 N8010BHurtado Miguel · Boise, IDBuilt 2000 · S/N 6139425 N804FJLorenz Peter · Jefferson, WIBuilt 2000 · S/N FRE 01 N8067EHarden Melvin R · Dalton, GABuilt 1996 · S/N 3238 N8068PWatson Robert S · South Gibson, PABuilt 1985 · S/N 850041 N8082BMay John D · Austin, ARBuilt 2000 · S/N 728 N820HZNull Clifford M · Punxsutawney, PABuilt 2017 · S/N 35020 N821ACGrenga Robert · Gilbert, AZBuilt 2007 · S/N AO48 M19 N82ASSteinbach Art · Redding, CABuilt 1983 · S/N 0001 N8546EPatton James E · Spencer, INBuilt 1994 · S/N E238 N86048Life Lawrence D · Newton, KSS/N 62050A N86052Life Lawrence D · Newton, KSBuilt 2007 · S/N SR 179 N911CZZechmann Casey M · Grangeville, IDBuilt 2020 · S/N 02 N9130XOsborn Gregory W · Burtchville, MIBuilt 2003 · S/N 290 N9258AFroehlich Joel M · Mcqueeney, TXS/N 2007-0258 N93097Colstrup Dennis J · Albert Lea, MNBuilt 2007 · S/N SN672 N939EBBorne Eugene P II · Reserve, LABuilt 2003 · S/N 1439 N94279Braddy Robert S · Peachtree City, GABuilt 2007 · S/N 001 N94324Henning Karl L · Burr Ridge, ILBuilt 1997 · S/N 130 N94723Hicks James E · Mount Union, PABuilt 2000 · S/N BR004 N952BGEdson Garry Steven · La Porte, INBuilt 2022 · S/N 23 N9531VPeachey Samuel R · Belleville, PABuilt 2008 · S/N F1125 N959MKDelgado Ruben E · San Antonio, TXS/N GT2801348 N95WLNichols Michael H · Thompson Falls, MTBuilt 1999 · S/N 0300013 N967JDSale Reported · Boscobel, WISale reported, canceledBuilt 2007 · S/N JFD001 N9862ZAerolite 103 LLC · Deland, FLFirst renewal noticeBuilt 2000 · S/N A-AWI-101200-78-R447 N98XTDutton Bradley E · Navarre, OHBuilt 2007 · S/N SD1647 N994TADavella Jonah Matthew · Kingston, TNBuilt 2001 · S/N 456 N99XZWyckoff Dennis M · Germantown Hills, ILBuilt 1993 · S/N 93202

Back to Rotax 447