Skip to content

Registered aircraft · 1,439

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

N9130UTravis Gary E · Raleigh, NCBuilt 1976 · S/N 15078081 N9131UVarivoda Marina Y · Miami, FLS/N 15078082 N9132UBishop Michael J · Poulsbo, WABuilt 1976 · S/N 15078083 N9140ULegore William G · Windsor, WIBuilt 1976 · S/N 15078091 N9143USherer Preston A · Watertown, WIBuilt 1976 · S/N 15078094 N9145USharp Wayne H · Mena, ARBuilt 1976 · S/N 15078096 N914EYDreimiller Raymond J Jr · Bloomfield, NYBuilt 1976 · S/N 15079131 N9151UAdvanced Aviation LLC · New Century, KSBuilt 1976 · S/N 15078102 N9156UHangar6 Aviation LLC · Apex, NCBuilt 1976 · S/N 15078107 N9157URoss Stephen D · Greenfield, OHS/N 15078108 N9159UHac Plane LLC · Sugar Land, TXBuilt 1976 · S/N 15078110 N9162UDag Arda Orcun · Mount Dora, FLBuilt 1976 · S/N 15078113 N9164UUnderwood Callum M · Canton, GABuilt 1976 · S/N 15078115 N9165ULudwiczak Damian · Medina, OHBuilt 1976 · S/N 15078116 N9166UKsnl Aero LLC · Shawnee, OKBuilt 1976 · S/N 15078117 N9167UTobin Dustin J · Hesperia, CABuilt 1976 · S/N 15078118 N9168UC150 LLC · Gilbert, AZBuilt 1976 · S/N 15078119 N9169UVipperman Richard Madison Jr · Martinsville, VABuilt 1976 · S/N 15078120 N9174UYoung Steven J · Taneyville, MOBuilt 1976 · S/N 15078125 N9178UPerguson Robert C · Converse, TXBuilt 1976 · S/N 15078129 N9179UHartman Karin R · Kokomo, INBuilt 1976 · S/N 15078130 N9183UJody M Bryson DBA · Richards, MOBuilt 1976 · S/N 15078134 N9185UChristopher P Riley · Everett, WABuilt 1976 · S/N 15078136 N9186USmith John Dial Jr · Lexington, SCBuilt 1976 · S/N 15078137 N9191UN9191u LLC · California, MDBuilt 1976 · S/N 15078142 N9193UVan Buskirk Bill J · Wasilla, AKBuilt 1976 · S/N 15078144 N9197UWarfel Everett E · Greenwood, DEBuilt 1976 · S/N 15078148 N9200UCherry Hill Aviation Inc · Freetown, INBuilt 1976 · S/N 15078151 N9203UAlaskan Mariners Inc · Homer, AKBuilt 1976 · S/N 15078154 N9208UEllefson Nicholas · Duluth, MNBuilt 1976 · S/N 15078159 N9210UKing Bill R · Cadillac, MIBuilt 1976 · S/N 15078161 N9211UMaster Gregory A · Mesa, AZBuilt 1976 · S/N 15078162 N9217UWallace John L · Bethel, AKS/N 15078167 N9218UHolzgrove Thomas H · Pipestone, MNS/N 15078168 N9219UCarlson Farms Inc · Plentywood, MTBuilt 1976 · S/N 15078169 N9222UJdl Services LLC · Centreville, MDBuilt 1976 · S/N 15078172 N9225UPrecise Flight LLC · Waukesha, WIBuilt 1976 · S/N 15078175 N9226UMcnamara Gavin E W · Rancho Cucamonga, CABuilt 1976 · S/N 15078176 N922SWGhulam A Jafferi · South Miami, FLS/N 15076659 N9231UCreek William M · Emeryville, CABuilt 1976 · S/N 15078181 N9232UWalnut Grove Properties LLC · Eureka, ILBuilt 1976 · S/N 15078182 N9233UThorstad Vaughn A · Fargo, NDBuilt 1976 · S/N 15078183 N9242ULiggett Garrett C · Eminence, MOBuilt 1976 · S/N 15078192 N9244UCairo Flying Club Inc · Cairo, ILBuilt 1976 · S/N 15078194 N9245UTaylor James R · Murfreesboro, TNS/N 15078195 N9246UArtemis Aviation Group LLC · Kalispell, MTBuilt 1976 · S/N 15078196 N9251UCarpenter James M · Marion, ARS/N 15078201 N9252UHoffman William C · Rostraver Township, PABuilt 1976 · S/N 15078202 N9257ULiberty Flyers Inc · Ramsey, MNBuilt 1976 · S/N 15078207 N9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1976 · S/N 15078209

Back to Cessna 150M