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.

N2274JStone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N 15065474 N2279JN2279j LLC · Burr Oak, MIBuilt 1966 · S/N 15065479 N2282JReiner William · Anchorage, AKBuilt 1966 · S/N 15065482 N2283JHill Douglas G · Winnebago, MNBuilt 1966 · S/N 15065483 N2295JPloyhart Edwin J · Harwood, NDBuilt 1966 · S/N 15065495 N2298JRoth Mark E · Stevensville, MTBuilt 1966 · S/N 15065498 N2299JMclaughlin Edward T · Silverdale, WAS/N 15065499 N2396UMurphy Brandon C · Portland, TNBuilt 1966 · S/N 15065077 N2401JOne-Fifty Inc · Myerstown, PAS/N 15065501 N2403JCordell John M · Rochester, WABuilt 1966 · S/N 15065503 N2408JIflycali LLC · Rancho Murieta, CABuilt 1966 · S/N 15065508 N2410JHeinze Gregory L · Little Rock, ARBuilt 1966 · S/N 15065510 N2411JKenney Jason M · Grand Rapids, MIBuilt 1966 · S/N 15065511 N2419JScheller Dwain A · Grand Rapids, MIBuilt 1966 · S/N 15065519 N2420JRailsback Craig S · Huntington Beach, CAS/N 15065520 N2423JHarris Patrick S · Chamberlain, SDS/N 15065523 N2430JColster John W · Centerview, MOBuilt 1966 · S/N 15065530 N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534 N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535 N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538 N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539 N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540 N2442JOlson Lanny R · Huron, SDS/N 15065542 N2460JSmith Harry N · Glendale, AZBuilt 1966 · S/N 15065560 N2461JWeidemann Wendell S · Madison, WIBuilt 1966 · S/N 15065561 N2462JBercaw Vaughn L · Beach City, TXBuilt 1966 · S/N 15065562 N2463JTony Noyes · Lewisville, TXS/N 15065563 N2465JWalther Nora P · Ocala, FLBuilt 1966 · S/N 15065565 N2467JHenderson Samuel · Wasilla, AKS/N 15065567 N2471JKrisch Garry A · Kenedy, TXBuilt 1966 · S/N 15065571 N2474JSingleton Addison L · New Bedford, MABuilt 1966 · S/N 15065574 N2484JTundra Aviation Inc · Casselton, NDBuilt 1966 · S/N 15065584 N2485JPercival Sheila · Watson, ILS/N 15065585 N2488JMcdonald Nicholas W · Phoenix, AZBuilt 1966 · S/N 15065588 N2489JVan Velson Richard Lee · Brule, NEBuilt 1966 · S/N 15065589 N2490JSchmitt Rudy · Brookshire, TXBuilt 1966 · S/N 15065590 N2492JGerke Russell L · Kalispell, MTBuilt 1966 · S/N 15065592 N2493JBrunson Anthony W · Evans, GABuilt 1966 · S/N 15065593 N2500QSaydun LLC · Richardson, TXBuilt 1967 · S/N 15066600 N2608JDriftless Aero LLC · Montfort, WIBuilt 1966 · S/N 15065608 N2610JTrotzke Samuel P · North Pole, AKBuilt 1966 · S/N 15065610 N2613JKoontz Jeffrey T · Phoenix, AZBuilt 1966 · S/N 15065613 N2615JBatt Keith P · Fairfield, CABuilt 1966 · S/N 15065615 N2619JFortier Richard · Chico, CABuilt 1966 · S/N 15065619 N2620JBenabdallah Mohamed · Lutz, FLBuilt 1966 · S/N 15065620 N2628JGoslin Joel · Anchorage, AKBuilt 1966 · S/N 15065628 N2629JMartin Jonathan W · West Grove, PABuilt 1966 · S/N 15065629 N2634JCupka Michael J · North Waterboro, MEBuilt 1966 · S/N 15065634 N2635JWakefield Diep Thao T · Kelseyville, CABuilt 1966 · S/N 15065635 N2636JScott William B · Owensville, INBuilt 1966 · S/N 15065636

Back to Cessna 150G