Skip to content

Lycoming O-290-D2

Registered aircraft · 58

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

N10CFUrwin Keith · Warren, ORBuilt 2014 · S/N 203 N10DDFrasca Air Museum Inc · Urbana, ILBuilt 1974 · S/N 1 N1230AHlavnicka Ruth M · Big Sandy, MTBuilt 2006 · S/N S1-06 N135PZGotschall John F · Silverdale, WABuilt 1995 · S/N 1 N141STBeeghly James H L · Coralville, IABuilt 2008 · S/N ST-001-08 N149RMCollins Robert M · Cape Elizabeth, MEBuilt 2014 · S/N 90763 N1564PJsfm Flyers LLC · Saint Cloud, MNBuilt 1954 · S/N 18-3725 N17EBJennings Howard E Jr · Utica, MSBuilt 2009 · S/N 001 N200JGood Aviation LLC · Sidney, MEBuilt 2006 · S/N HC-035 N207ENWhitman Bruce R · Lowell, MIBuilt 2012 · S/N 06 N225George Thomas Nemeth · Hilliard, OHBuilt 2012 · S/N 803 N2474ZTeufel Jeffrey · North Pole, AKBuilt 1954 · S/N 18-3592 N24WGVassberg Eric D · Aledo, TXBuilt 2023 · S/N 2802 N290RLRichardson Scott · Sunnyvale, CABuilt 2020 · S/N 235-181-173 N298HShetter North A · Menominee, MIBuilt 2014 · S/N 089 N306EBGoral Jan · Tigard, ORBuilt 2012 · S/N 1156 N3224BSkyward Solutions Inc · Lewes, DEBuilt 1954 · S/N 22-2052 N330JHHoover Jerrald J · Yelm, WABuilt 1999 · S/N 1058 N3390AEngen John E · Soldotna, AKBuilt 1954 · S/N 22-1661 N35415Irving Kyle P · Wasilla, AKS/N 5-666 N35WTThomas Lynn K · Searsmont, MEBuilt 2007 · S/N TF-1 N393TFGibsons Gas Inc · Holland, NYS/N 3 N4431J & J Aircraft Holdings LLC · Vonore, TNS/N GV1-L100 N4464GArnold Thomas · Taft, CABuilt 2008 · S/N 2581 N448TLClark Ashley · Peachtree Corners, GABuilt 2013 · S/N 65-7557 N46FNNewman Alfred F Jr · Trenton, SCBuilt 2011 · S/N FN2011 N4876AMontgomery Daniel G · Wasilla, AKBuilt 1956 · S/N 18-4975 N493JPRadtke Michael K · Mesilla, NMBuilt 2006 · S/N 2004 N49DTClark Coy A · Raeford, NCBuilt 1957 · S/N 7FC-117 N515ZMcrae David B · Advance, NCBuilt 2020 · S/N 7911 N54YEBrown Lonnie S · Lone Jack, MOBuilt 1954 · S/N 18-3605 N559WKleiss Norman J · Cloverdale, INBuilt 2006 · S/N 0001 N55GLBates John W · Westerly, RIBuilt 2016 · S/N GL-003 N59262Tabbert William Stanley · Diamondhead, MSS/N F-2 N617WGGerszewski Wayne C · Park River, NDBuilt 2025 · S/N 014 N6296LHansen Roy J · Pacific City, ORBuilt 1973 · S/N AA1B-0096 N643HPKubin Mark A · Ward, ARBuilt 2011 · S/N 643 N703TRMaisel Martin D · Lincoln, CABuilt 2016 · S/N 77018LF N710JFStearns Todd C · Cora, WYBuilt 2008 · S/N J-001 N720RTLeaders Kurt W · Clear Lake, MNBuilt 1985 · S/N 678 N750WLMiller John J · Canastota, NYBuilt 2015 · S/N 75-8701 N767ABKoelsch Anthony W · Anchorage, AKBuilt 2007 · S/N AB-1 N780KGGronewald Kenneth R · Hysham, MTBuilt 2024 · S/N 3580 N7814MMenefee Michael · Bremerton, WABuilt 2025 · S/N 800 N805RFConner Kevin R · Collinsville, OKBuilt 2014 · S/N 805 N871CGBunting Cameron E · Lake City, FLBuilt 2017 · S/N 0001 N878RMBowman Mark R · Tillamook, ORBuilt 2013 · S/N 145 N8880SJohnson Kenneth E · Mahtomedi, MNBuilt 2020 · S/N 10879 N90403Rintamaki Peter A · Meridian, IDBuilt 2007 · S/N R-001 N915NCMiller Nevin D · Naples, IDBuilt 2009 · S/N 91522

Back to Lycoming O-290-D2