Skip to content

Registered aircraft · 1,065

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

N8626GMcflight Aviation LLC · Highland, UTBuilt 1966 · S/N 15062726 N8627GMahaini Saad · Lucas, TXBuilt 1966 · S/N 15062727 N8628GLongmuir Charles H · Newport, MES/N 15062728 N8628SDiaz George D · Tucson, AZS/N 15061928 N8630GGoehring Melissa S · Grand Rapids, MIBuilt 1965 · S/N 15062730 N8631SSteiger Marley C · Glenham, SDBuilt 1965 · S/N 15061931 N8632GChappell Stephen · Wilmington, NCBuilt 1966 · S/N 15062732 N8633SUhler John A · Rimrock, AZBuilt 1965 · S/N 15061933 N8634GRegistration Pending · Princeton, MARegistration pendingBuilt 1966 · S/N 15062734 N8634SHersom Jeffrey T · Helena, MTBuilt 1965 · S/N 15061934 N8635GSmith Andrew W · Willow, AKBuilt 1965 · S/N 15062735 N8635SWood Timothy M · Jefferson, MES/N 15061935 N8637GReichenbach Louis · Northville, MIBuilt 1966 · S/N 15062737 N8638SLyon Ronald C · Berlin, VTBuilt 1965 · S/N 15061938 N8639GRegistered aircraftBuilt 1966 · S/N 15062739 N8640GRoss Peter W · Lufkin, TXBuilt 1965 · S/N 15062740 N8641SSimmons Anthony C Jr · Allendale, SCBuilt 1965 · S/N 15061941 N8644GMelin Jeff C · Kenmare, NDBuilt 1965 · S/N 15062744 N8644SRiggan Charles H · Oxford, NCBuilt 1965 · S/N 15061944 N8646SFoster Brian E · Bartley, NEBuilt 1965 · S/N 15061946 N8648SSnodgrass Gavin I · Belle, MOS/N 15061948 N8649GMullins Steve F · Belews Creek, NCBuilt 1965 · S/N 15062749 N8649SGuffey Edward B · Bessemer City, NCBuilt 1965 · S/N 15061949 N8650SGrant Clinton A Trustee · Portage Des Sioux, MOS/N 15061950 N8652SKindel Michael W · Bismarck, NDS/N 15061952 N8653GArmstrong John K · Lovington, NMS/N 15062753 N8657GClayton Patrick D · Hazen, ARS/N 15062757 N8658GWestrum Sean Ross · Norwalk, IAS/N 15062758 N8658SBird Jared N · Mission, TXBuilt 1965 · S/N 15061958 N8659GCoker Jason John · Caribou, MEBuilt 1966 · S/N 15062759 N8659SRegistration Pending · Davenport, FLRegistration pendingBuilt 1965 · S/N 15061959 N8660SDepaula Saulo C T · Princeton, MAS/N 15061960 N8662SRegistration Pending · Lynchburg, VARegistration pendingBuilt 1965 · S/N 15061962 N8663GLake George Aviation LLC · Warwick, NYBuilt 1966 · S/N 15062763 N8664SMansuroff Eugene E · Carteret, NJBuilt 1965 · S/N 15061964 N8668GClosson Luke E Jr · Valdosta, GABuilt 1966 · S/N 15062768 N8668SCooper Jerry A · Kennewick, WAS/N 15061968 N8670SFlying Hawks Ranch LLC · Bruning, NEBuilt 1965 · S/N 15061970 N8672SAres Aviation LLC · Holly Ridge, NCBuilt 1965 · S/N 15061972 N8677SClay Robert W · Hancock, MNBuilt 1965 · S/N 15061977 N8680SMaestro Aviation LLC · Anson, TXBuilt 1965 · S/N 15061980 N8681GGrammer Samuel C · Vernal, UTBuilt 1966 · S/N 15062781 N8684GTorres Andres · Plano, TXBuilt 1966 · S/N 15062784 N8686SKaines John L · Ludington, MIBuilt 1965 · S/N 15061986 N8687GLindsey John Monroe · Dover, ARBuilt 1966 · S/N 15062787 N8688SKubik Darrel J · Boise, IDBuilt 1965 · S/N 15061988 N8690SSandy River Flying Club · Phillips, MEBuilt 1965 · S/N 15061990 N8691GWings Over Texas Holdings LLC · Denton, TXBuilt 1966 · S/N 15062791 N8691SBonner John A III · Ocala, FLBuilt 1965 · S/N 15061991 N8692SRobinson Deon D · Mesquite, TXBuilt 1965 · S/N 15061992

Back to Cessna 150F