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.

N105ESFrederick Sport Flyers Inc · Washington Grove, MDS/N 15079000 N110FMHorton Maya Patryce · Phoenix, AZBuilt 1975 · S/N 15076809 N110SSEdwards Pacific Aviation Corp · Dover, DEBuilt 1976 · S/N 15078126 N111HCBennett Miranda Mathis · Fairhope, ALBuilt 1975 · S/N 15077675 N113PBRegistration Pending · North Little Rock, ARRegistration pendingBuilt 1976 · S/N 15078263 N113SSSoutheastern Oklahoma State University · Durant, OKBuilt 1975 · S/N 15076645 N117SSSoutheastern Okalhoma State University · Durant, OKBuilt 1976 · S/N 15079025 N118SSSoutheastern Oklahoma State University · Durant, OKBuilt 1975 · S/N 15077132 N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597 N120SSSoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078900 N121SSGraber Matthew P · Mountain View, CABuilt 1974 · S/N 15076450 N1222WPlanes Over Plains LLC · Benton, KSBuilt 1974 · S/N 15075991 N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300 N148ELFrazier James M III · Saint Marys, KSBuilt 1975 · S/N 15077412 N14SWTriple R Ministries Inc · Crestview, FLBuilt 1974 · S/N 15075931 N150AJChristianson Alan J · Washougal, WAS/N 15076664 N150EQSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076259 N150FFKelly Paul M · Granite Bay, CABuilt 1975 · S/N 15076716 N150GNCarr Greg Wayne · Mccloud, CABuilt 1975 · S/N 15077043 N150HBAttack Cactus LLC · Phoenix, AZBuilt 1974 · S/N 15075879 N150HKCarboneau Kyle R · Chugiak, AKS/N 15076953 N150JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 15075916 N150LLColtharp Linda A Trustee · Austin, TXBuilt 1975 · S/N 15076617 N150MDRegistered aircraftAssigned, pending cancellationS/N 15078214 N150MVSabia Robert V · San Antonio, TXBuilt 1976 · S/N 15078815 N150RDMiller Robert C · Marshallberg, NCBuilt 1975 · S/N 15077548 N150RROdell George · East Hampton, CTBuilt 1975 · S/N 15077320 N150UCNate Abel Flying Club · Ft Worth, TXBuilt 1976 · S/N 15078719 N150VShingle Knob LLC · Blythewood, SCBuilt 1974 · S/N 15076162 N150XPSilver Skies LLC · Henderson, NVBuilt 1975 · S/N 15077183 N151DABaumgarten Robert J · Mobile, ALBuilt 1975 · S/N 15076555 N151EDBishop Patrick M · Reading, MABuilt 1974 · S/N 15076126 N154DAOrr Lawrance C · Sacramento, CAS/N 15079253 N154SWHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1975 · S/N 150-77204 N156DARound Trip Lc · Elkhart, KSS/N 15079190 N15TYArneson Kenneth W · Beaverton, ORBuilt 1975 · S/N 150-76713 N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474 N170KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 15079154 N17FGWard Bruce L · Key West, FLBuilt 1976 · S/N 15077906 N186ARAircraft Holdings LLC · Morgantown, WVS/N 15077554 N187ERMustang Sally Aviation LLC · Camden, SCBuilt 1975 · S/N 15077004 N189ERMustang Sally Aviation LLC · Camden, SCBuilt 1974 · S/N 15076412 N18YZHightower Ronny · Blanchard, OKBuilt 1975 · S/N 15076721 N1976HOkaeronut LLC · Ponca City, OKBuilt 1975 · S/N 15077112 N2046ULegacy Aviation Foundation Inc · Staten Island, NYBuilt 1975 · S/N 150-76961 N211TSalazar Frank A · Los Angeles, CABuilt 1975 · S/N 15077046 N212AFDoolittle Aero LLC · Goodyear, AZS/N 15076277 N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002 N222PAFrank Eric A · East Troy, WIBuilt 1976 · S/N 15078669 N222SADenny Robert C · Fort Myers, FLS/N 15078576

Back to Cessna 150M