Skip to content

Registered aircraft · 37

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

N10765Madden William L · Las Cruces, NMBuilt 1931 · S/N 101 N10779Eagles Mere Air Museum Foundation · Wayne, PABuilt 1930 · S/N 103 N11735Dilse Ted D · Scranton, NDBuilt 1934 · S/N A-662 N11747Lamb David W · Ellerbe, NCBuilt 1934 · S/N 676 N11750Golden Age Air Museum · Bethel, PABuilt 1934 · S/N A-679 N11751Cox Donald E Jr · Fayetteville, GABuilt 1934 · S/N A-680 N11754Colton F D · Canby, ORBuilt 1934 · S/N A-685 N11761Essey Helen P · Laurinburg, NCS/N A-690 N11767Art Ticulate Tees LLC · Hazard, KYBuilt 1935 · S/N A696 N11768White Paul M · Elizaville, NYBuilt 1935 · S/N A697 N11776Robinson Stephen G · Livermore, CABuilt 1935 · S/N A-705 N11777Lerille Red · Lafayette, LABuilt 1935 · S/N A706 N11783Goudeau Todd J · Broussard, LABuilt 1935 · S/N A708 N11787Sale Reported · Mosinee, WISale reportedBuilt 1935 · S/N A-712 N11797Lerille Red · Lafayette, LABuilt 1937 · S/N A-721 N119VHistoric Aircraft Restoration Museum · Saint Louis, MOBuilt 1932 · S/N 628 N12361Mcbride Robert W Jr · Cedar Park, TXBuilt 1933 · S/N 650 N13139Alfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1932 · S/N 105 N15437Kegin Kevin Michael · Salem, ILBuilt 1936 · S/N A736 N15440Caldwell Collection Inc · Oklahoma City, OKBuilt 1936 · S/N A739 N16426Crestair Air LLC · Dover, DEBuilt 1937 · S/N A753 N16427Lerille Red · Lafayette, LABuilt 1937 · S/N A-754 N18168White Paul M · Elizaville, NYS/N A793 N19423Goettl Karl T · Clarkdale, AZBuilt 1938 · S/N A-775 N19424Cook Charles N · Lakeside, TXBuilt 1938 · S/N A-774 N19430Bonzon Jeffrey L · Largo, FLS/N A-781 N19433Schell Samuel E Jr · Littlestown, PABuilt 1939 · S/N A-783 N19434Bill Mcgowan Inc · Covington, LABuilt 1939 · S/N A784 N19438Craig Warren J · Ellerbe, NCBuilt 1940 · S/N A788 N20991Perry Aaron O · Piqua, OHBuilt 1938 · S/N G9 N20996Parsons Lee E · Carrollton, OHBuilt 1938 · S/N G-14 N350VDougherty Paul D Jr · Bethel, PABuilt 1930 · S/N 121 N429NRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1932 · S/N 618 N520WRoberts Nancy · Lomita, CABuilt 1930 · S/N 559 N537WCommand Aire LLC · Sitka, AKBuilt 1930 · S/N 561 N557WJames Patrick Lyons · Fort Ogden, FLBuilt 1931 · S/N 575 N583YMarshall Nicholas Beazley Aviation Museum Inc · Marshall, MOBuilt 1931 · S/N K-24

Back to Lambert R266