Skip to content

Registered aircraft · 976

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

N3074STail Aero Corp · Wilmington, DEBuilt 1967 · S/N 15066974 N3081SSproul Wendell C · Hermon, MEBuilt 1967 · S/N 15066981 N3083SPrather David H · Gig Harbor, WABuilt 1967 · S/N 15066983 N3084SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066984 N3085SVilleneuve Stephane A Peltereau · Fort Worth, TXBuilt 1967 · S/N 15066985 N3089SGrafious Jon · Coventry Township, OHBuilt 1967 · S/N 15066989 N3091SRempala Jill E · Saint Peters, MOBuilt 1967 · S/N 15066991 N3093SAdkins Dwain L · Sycamore, ILBuilt 1967 · S/N 15066993 N3095SCessna 3095s LLC · Colorado Springs, COBuilt 1967 · S/N 15066995 N3097SDaj Holdings Inc · Wilmington, DEBuilt 1967 · S/N 15066997 N3099SDrury Claude R · Denton, TXS/N 15066999 N3101JRobinson David N · Colleyville, TXBuilt 1966 · S/N 15065801 N3103JChiles Jimmy W · Rowlett, TXBuilt 1966 · S/N 15065803 N3108JBetzoldt Linda · Tecumseh, MIBuilt 1966 · S/N 15065808 N3109JShue Robert R Jr · Easley, SCBuilt 1966 · S/N 15065809 N3114JHibner Joseph W · Coldwater, OHBuilt 1966 · S/N 15065814 N3119JBerthelsen Mark A · Baker City, ORBuilt 1966 · S/N 15065819 N3122JMulvihill Murphy A · Northbrook, ILBuilt 1966 · S/N 15065822 N3127JHendry Joshua R · Carthage, TNBuilt 1966 · S/N 15065827 N3129JEagles Flying Club · Menominee, MIBuilt 1966 · S/N 15065829 N3130JStevens Donald R · North Plains, ORBuilt 1966 · S/N 15065830 N3133JFour Men And A Plane LLC · New Port Richey, FLBuilt 1966 · S/N 15065833 N3133XPolemarkis Anthony N · Williams Bay, WIBuilt 1966 · S/N 15064533 N3134JOverton Asset Group LLC · St Marvs, IABuilt 1966 · S/N 15065834 N3134XMachac Milton · Waller, TXRegistration expired, pending cancellationBuilt 1966 · S/N 15064534 N3135XWilliams Vaughn E · Duncannon, PABuilt 1966 · S/N 15064535 N3136JGriffith Charles B · Santa Maria, CABuilt 1966 · S/N 15065836 N3138XBoardman Thomas M · Greenwich, NYBuilt 1966 · S/N 15064538 N3140JSmith Franklin R Sr · York, SCBuilt 1966 · S/N 15065840 N3140XGerasimov Gennady · Jefferson City, MOBuilt 1966 · S/N 15064540 N3141XMalo Lee M · Peabody, MABuilt 1966 · S/N 15064541 N3144JChaffey Union Junior College District · Alta Loma, CABuilt 1966 · S/N 15065844 N3147JRegistered aircraftS/N 15065847 N3148JWoerle Edward R · Rossville, TNBuilt 1966 · S/N 15065848 N3150JKeown Kyle W · Saint Charles, MOBuilt 1966 · S/N 15065850 N3159JIcaro Flight Club Of Miami Inc · Miami, FLBuilt 1966 · S/N 15065859 N3162XSchilling Mark F · Clear Lake, SDBuilt 1966 · S/N 15064562 N3164XPeterson Dennis E · Cambridge, MNBuilt 1966 · S/N 15064564 N3166XDobbelaere Rick H · Oakwood, OHBuilt 1966 · S/N 15064566 N3167JRay Charlie B DBA Chucks Air Service · Prosser, WABuilt 1966 · S/N 15065867 N3169XVirgilio Domenico · Rochester Hills, MIBuilt 1966 · S/N 15064569 N3170JDobrzynski Andrzej J · Chicago, ILBuilt 1966 · S/N 15065870 N3170XFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 15064570 N3171JRay Charles B · Prosser, WAS/N 15065871 N3171XJohnson Christopher A · San Diego, CABuilt 1966 · S/N 15064571 N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573 N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574 N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875 N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876 N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576

Back to Cessna 150G