Skip to content

Registered aircraft · 41

Aircraft of this model 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 aircraft_model_code IN ('5810104')
  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 aircraft_model_code IN ('5810104')
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.

N11735Dilse Ted D · Scranton, NDBuilt 1934 · S/N A-662 N11737Hebert Leonard W · Logan, UTS/N A664 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 N11760Davis Richard M · League City, TXBuilt 1934 · S/N A-689 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 N11782Iler Elden · Van Nuys, CAS/N A707 N11783Goudeau Todd J · Broussard, LABuilt 1935 · S/N A708 N11787Sale Reported · Mosinee, WISale reportedBuilt 1935 · S/N A-712 N11793Reed Gary L · Bethel, OHBuilt 1936 · S/N A717 N11795Gallarate Raymond D · Sonoma, CABuilt 1937 · S/N A-719 N11797Lerille Red · Lafayette, LABuilt 1937 · S/N A-721 N15427Lightsey Mark A · Pleasant View, TNBuilt 1930 · S/N A-727 N15429Niemyjski Justin S · Franksville, WIBuilt 1936 · S/N A730 N15437Kegin Kevin Michael · Salem, ILBuilt 1936 · S/N A736 N15440Caldwell Collection Inc · Oklahoma City, OKBuilt 1936 · S/N A739 N16423Niemyjski Trevor G · Union Grove, WIS/N A-750 N16426Crestair Air LLC · Dover, DEBuilt 1937 · S/N A753 N16427Lerille Red · Lafayette, LABuilt 1937 · S/N A-754 N18056Bowe Andrew J Jr · Poplar Grove, ILBuilt 1937 · S/N A-765 N18062Slack Jonathan D · Bonfield, ILBuilt 1938 · S/N A-770 N18166Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 791 N18168White Paul M · Elizaville, NYS/N A793 N18176Reese Flying Service Inc · Muncie, INBuilt 1941 · S/N A-802 N18184Lerille Red · Lafayette, LABuilt 1941 · S/N A-810 N18186Davies Samuel R · Port Angeles, WAS/N A-812 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 N19437Lerille Red · Lafayette, LAS/N A-787 N2701CCournoyer John J · Ellsinore, MOS/N AF-826 N38917Flying Low Racing LLC · Oklahoma City, OKBuilt 1941 · S/N A-840 N410YLove Kenneth L · Ronda, NCBuilt 1936 · S/N A742

Back to Monocoupe 90A