Skip to content

Lycoming O-290-D

Registered aircraft · 45

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

N105JESchier Del J · Lake City, FLBuilt 2015 · S/N 3050 N128FFThomas Blake W · The Villages, FLBuilt 2008 · S/N 6128 N129JBKuykendall Robert J · Jefferson, WIBuilt 2009 · S/N 6-4584 N1364AFranz Stanley · Yakima, WABuilt 1951 · S/N 18-1190 N1553MRubbert Jan D · Upham, NDBuilt 1947 · S/N 12-3125 N1573ZSmith David J · Duluth, MNBuilt 2014 · S/N 001 N202PTHerreman Brian J · Aguila, AZBuilt 2017 · S/N 0016 N234BRHolmes Tracy H · Boerne, TXBuilt 2015 · S/N 001 N25801Vessel Of Honour Ministries · Bluff City, TNBuilt 2010 · S/N 278 N299STThibodaux Scott A · Thibodaux, LABuilt 2009 · S/N ST003 N328LPNice Volmer LLC · Toledo, OHBuilt 1969 · S/N WJBC-1-1-67 N33082Lewis Milton K · Cortez, COBuilt 1940 · S/N 5-431 N3538MBruesch John E · Long Grove, IABuilt 2025 · S/N SA-SW2121108 N397PAStelzle Scott A · Templeton, CABuilt 1940 · S/N 5-397 N410JKWhite Clay · Broken Bow, OKBuilt 2020 · S/N 8283 N42TZBooe Matt · Centerpoint, INS/N 44 N43834Mclellan Robert L Jr · Russellville, KYBuilt 2006 · S/N 16 N4600Stevens Mike R · Duluth, MNBuilt 1971 · S/N 46 N4825MCottle John G · Enid, OKBuilt 1995 · S/N 215 N49GDMichel Kris · Shelter Cove, CABuilt 1983 · S/N RS-10 N505TFHawkins Larry L · Farmington, NMBuilt 2021 · S/N 11456 N5094BSmith Glenn · Orange Park, FLBuilt 2007 · S/N 001 N5929ZBrown Dave M · Crescent City, CABuilt 2013 · S/N 75-8517 N5976BVarney Walter E · Charlotte, NCBuilt 2018 · S/N 25515 N622PPHyde Russell M · Rutherfordton, NCBuilt 1947 · S/N 12-2642 N6339Leonard Nick A · Pipe Creek, TXBuilt 2009 · S/N G-2 N64VSSignorile Raffaele · Garfield, NJBuilt 2013 · S/N 65-8851 N66PKMorton Dennis D · La Harpe, ILBuilt 2021 · S/N 1103 N681KEEckstein Kenneth A · Simpsonville, SCBuilt 2023 · S/N 112012 N687LPForgotten Heroes Foundation · Chesapeake, VAS/N 012 N6881KTime 2 Fly LLC · Baldwinsville, NYBuilt 1979 · S/N 16-724 N72454Dawson Adam J · Eveleth, MNBuilt 1952 · S/N 18-1715 N7725KKansas State University Salina · Salina, KSBuilt 1950 · S/N 20-547 N772LMKpk Holdings LLC · East Helena, MTBuilt 1940 · S/N 5-239 N7754KKoch Paul D · Morgan Hill, CABuilt 1951 · S/N 20582 N7781KEvans Thomas Sidney · Wilmer, ALBuilt 1951 · S/N 20-607 N819YKBoswell Jeffrey · Kingsland, GABuilt 2017 · S/N 007 N81LERieger Mark W · Woodland, CAS/N 701 N849JBeam Jeffrey W · Arkansas City, KSBuilt 2008 · S/N 247 N853SPPavilon Clemens J · Bolingbrook, ILS/N 002 N8728CBateman Jon L · Colville, WABuilt 2014 · S/N 6795 N872SCLang Christopher G · New Hampton, NHBuilt 2019 · S/N 001 N873YDNelson Gerald R · Texarkana, ARBuilt 2021 · S/N 1931 N942SBGarvey John D · Timbercreek, TXBuilt 2007 · S/N 90835 N998ZWeimer Andy A · Pierce, IDBuilt 2009 · S/N 519-50

Back to Lycoming O-290-D