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.

N2647JHumble Tony R · Signal Mountain, TNBuilt 1966 · S/N 15065647 N2648JColonial Air Inc · New Bedford, MABuilt 1966 · S/N 15065648 N2650JNoll Cheryl A · Franklin, NCBuilt 1966 · S/N 15065650 N2656JSperling Gabriel E · Silverdale, WABuilt 1966 · S/N 15065656 N2658JLife Finds A Way LLC · Sarasota, FLBuilt 1966 · S/N 15065658 N2662JHanel Bruce · Placerville, CABuilt 1966 · S/N 15065662 N2670JMiw Airmen Inc · Marshalltown, IABuilt 1966 · S/N 15065670 N2671JSherman Phillip A · Mansfield, OHBuilt 1966 · S/N 15065671 N2673JWest David V · Sandusky, OHBuilt 1966 · S/N 15065673 N2679JJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1966 · S/N 15065679 N2682JCooper David J · Gravette, ARBuilt 1966 · S/N 15065682 N2686JMiller Mackenzie · Johnsonburg, PABuilt 1966 · S/N 15065686 N2687JBridgwater David A · Mcallen, TXBuilt 1966 · S/N 15065687 N2692JDowning Eric D · Saint Charles, MOBuilt 1966 · S/N 15065692 N2697JSalem Aero Club Inc · Bridgeton, NJBuilt 1966 · S/N 15065697 N2698JKruglov Stephan · Mundelein, ILBuilt 1966 · S/N 15065698 N2701SLeavitt Mark Richard · La Verkin, UTBuilt 1967 · S/N 15066601 N2705SCarter James E · Thornville, OHBuilt 1967 · S/N 15066605 N2706SWings With The Word · Sanford, MEBuilt 1967 · S/N 15066606 N2712SKelly Matthew Raymond · New Florence, MOBuilt 1967 · S/N 15066612 N2716SWright Herbert L · Vickery, OHBuilt 1967 · S/N 15066616 N2717SMartin Tyler · Pompano Beach, FLBuilt 1967 · S/N 15066617 N2718SBurroughs David G · El Paso, ILBuilt 1967 · S/N 15066618 N2721SPeyton Investments LLC · Washington, NCS/N 15066621 N2727SMiller Colin B · Fargo, NDBuilt 1967 · S/N 15066627 N2729SDates Lauren C · Red Creek, NYBuilt 1967 · S/N 15066629 N2737SBlock Oliver L · Nashville, TNBuilt 1967 · S/N 15066637 N2745SGobble Larry L · Williamson, GABuilt 1967 · S/N 15066645 N2746SBryant Stan M · Derby, KSBuilt 1967 · S/N 15066646 N2750SMcmichael Olen G · Antwerp, OHBuilt 1967 · S/N 15066650 N2752SWhite Orion H · Moses Lake, WAS/N 15066652 N2753SSlownlow LLC · Kalispell, MTBuilt 1967 · S/N 15066653 N2754SGaddis Rebekah J · Valley City, OHBuilt 1967 · S/N 15066654 N2758SBogner Edward R · Santa Cruz, CABuilt 1967 · S/N 15066658 N2760SBond Doyle G · Walker, LABuilt 1967 · S/N 15066660 N2763SMoore Park · Byron, GABuilt 1967 · S/N 15066663 N2764SBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066664 N2766SJohnston Beryle Lee · Franklin, PABuilt 1967 · S/N 15066666 N2768SSibley Michael Neal · Kenai, AKBuilt 1971 · S/N 15066668 N2770SBirk Ronald G · Wellington, NVBuilt 1967 · S/N 15066670 N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674 N2775SRichardson Arthur · Herald, CAS/N 15066675 N2778SStamper Brian L · Tucson, AZBuilt 1967 · S/N 15066678 N277KLCoombs Johnnie · Blue Mountain, MSBuilt 1966 · S/N 15064869 N2780SNapolitano Frank D · Howell, MIBuilt 1967 · S/N 15066680 N2781SGadberry Garth · Heath, TXBuilt 1967 · S/N 15066681 N2784SThomas Michael R · Marshall, MOS/N 15066684 N27TDMenor Michael D · Menominee, MIBuilt 1966 · S/N 15065577 N2800SSimpson Gavin J · Medford, ORBuilt 1967 · S/N 15066700 N2801SLavere Paul · Adams, NYBuilt 1967 · S/N 15066701

Back to Cessna 150G