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.

N714CLStrategic Aircraft Management LLC · Fairbanks, AKS/N 15079073 N714CPWentzien Derald E · Newark, DEBuilt 1976 · S/N 15079076 N714CUWestlye Kenneth J · Micanopy, FLBuilt 1976 · S/N 15079081 N714CYGilman Yoel · Aurora, COBuilt 1976 · S/N 15079085 N714DDDunaire LLC · Mechanicsburg, PABuilt 1976 · S/N 15079089 N714DFOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15079091 N714DGParr Aviation LLC · Monrovia, MDBuilt 1976 · S/N 15079092 N714DNFour Delta November LLC · Sarasota, FLBuilt 1976 · S/N 15079097 N714DPDelaney John · Cottonwood, CABuilt 1976 · S/N 15079098 N714DQFly Me LLC · Sparta, TNBuilt 1976 · S/N 15079099 N714DRRegistration Pending · Putnam, ILRegistration pendingBuilt 1976 · S/N 15079100 N714DWErdman Daniel J · Hermosa Beach, CAS/N 15079105 N714DXGarner Michael Thompson · Lago Vista, TXBuilt 1976 · S/N 15079106 N714DZAkron Aviation Inc · Malvern, OHBuilt 1976 · S/N 15079108 N714EAGonzalez Loui · Bell Gardens, CABuilt 1976 · S/N 15079109 N714ECSieradzki Richard P · Novi, MIBuilt 1976 · S/N 15079111 N714EHMatthews David G · Middleton, IDBuilt 1976 · S/N 15079116 N714EMDowns Lindsey M · Fayetteville, GABuilt 1976 · S/N 15079120 N714ERB & R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 15079124 N714ESDrollinger Michael R · Grandview, WABuilt 1976 · S/N 15079125 N714ETGrenie Arles A · Richland Center, WIBuilt 1976 · S/N 15079126 N714EWBashore Barry A · Pleasant Hill, OHBuilt 1976 · S/N 15079129 N714EZSherrod Robert W Jr · Burleson, TXBuilt 1976 · S/N 15079132 N714FDSolida Christopher · Bunker Hill, INBuilt 1976 · S/N 15079135 N714FFAirgo Inc · Centralia, ILBuilt 1976 · S/N 15079137 N714FGTraining Services Inc T/A · Virginia Beach, VABuilt 1976 · S/N 15079138 N714FHPoliti Terris P · Lake Placid, NYBuilt 1976 · S/N 15079139 N714FKSmokejumper Aviation LLC · Winthrop, WABuilt 1976 · S/N 15079141 N714FMNorth Florida Flight School LLC · Tallahassee, FLBuilt 1976 · S/N 15079142 N714FWPilot Rise Aircraft Holdings LLC · Fort Worth, TXBuilt 1976 · S/N 15079151 N714GBBuchanan Michael Shane · Manchester, TNBuilt 1976 · S/N 15079155 N714GDRose Robert J · Grosse Ile, MIBuilt 1976 · S/N 15079157 N714GHStrauss Austin · Avon, OHBuilt 1976 · S/N 15079161 N714GJOlson John W · Jackson, MNBuilt 1976 · S/N 15079162 N714GKCashman Timothy J · Mercer Island, WAS/N 15079163 N714GLHall Johnie S · Kingsland, ARBuilt 1976 · S/N 15079164 N714GRStrine Russell A · Reading, PABuilt 1976 · S/N 15079169 N714GUIrwin Roberta L · San Diego, CABuilt 1977 · S/N 15079172 N714GYWilson William R · Halfway, ORS/N 15079176 N714GZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1977 · S/N 15079177 N714HBJ11 Air LLC · Dallas, TXBuilt 1977 · S/N 15079179 N714HHPhelps Clay DBA · Santa Paula, CABuilt 1977 · S/N 15079185 N714HKDent Kelly J · Locust Grove, GABuilt 1977 · S/N 15079187 N714HLSlate Mitchell P · Colorado Springs, COBuilt 1977 · S/N 15079188 N714HRHendry Joshua R · Carthage, TNS/N 15079193 N714HUSingh Paviter · Beavercreek, OHBuilt 1977 · S/N 15079196 N714HYLeft Final LLC · Gastonia, NCS/N 15079199 N714JMartinez Ivan · Oro Valley, AZBuilt 1977 · S/N 15079382 N714JCAries Flyers Inc · Santa Clara, CABuilt 1977 · S/N 15079203 N714JDGuthrie Bobby D · El Dorado, ARS/N 15079204

Back to Cessna 150M