Skip to content

Registered aircraft · 756

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

N22147Morris Gregory A · Arlington, TXFirst renewal noticeBuilt 1967 · S/N 15068095 N22150Cody Edward H · Benton City, WABuilt 1967 · S/N 15068098 N22151Soren Sky LLC · Riverside, CAS/N 15068099 N22153Carter Gary J · Manlius, NYBuilt 1967 · S/N 15068101 N22155Anady Aviation LLC · Hemet, CABuilt 1967 · S/N 15068103 N22157Potter Colin J · Piedmont, SDBuilt 1967 · S/N 15068104 N22158Million John B · Westminster, MDBuilt 1967 · S/N 15068105 N22159Registration Pending · Phoenix, AZRegistration pending, canceledBuilt 1967 · S/N 15068106 N22160Evert Linda L · Golden Valley, MNBuilt 1967 · S/N 15068107 N22162Red Oak Commuter LLC · Red Oak, IABuilt 1967 · S/N 15068108 N22170Taylor Warren D · Las Vegas, NVBuilt 1967 · S/N 15068114 N22172Soerens Thomas D · Saint Charles, ILBuilt 1967 · S/N 15068115 N22183Allworth Burton · Wapello, IAS/N 15068121 N22190Mulhall Kathy · Fishtail, MTBuilt 1967 · S/N 15068127 N22191Perry Oien · Deadwood, SDBuilt 1967 · S/N 15068128 N22192Pecinovsky Clair · Cresco, IABuilt 1967 · S/N 15068129 N22194Schmidt James P · Omaha, NEBuilt 1967 · S/N 15068130 N22196Showah Michael F · Scottsdale, AZBuilt 1967 · S/N 15068132 N22197Frallicciardi Vincent Jtrust · Madawaska, MEBuilt 1967 · S/N 15068133 N22203Koenig William J · Benedict, MDBuilt 1967 · S/N 15068138 N22208Lamb Ryan C · Munster, INBuilt 1967 · S/N 15068142 N22210Registration Pending · New River, AZRegistration pendingBuilt 1967 · S/N 15068144 N22243Crawford Stephen E · Corinth, TXS/N 15068162 N22245Vanderploeg Connie · Edmond, OKBuilt 1967 · S/N 15068164 N22250Rush Christopher C · Anchorage, AKBuilt 1967 · S/N 15068167 N22251Barber Michael L · Igo, CABuilt 1967 · S/N 15068168 N22252Heid Nathan E · Nevada, OHBuilt 1967 · S/N 15068169 N22253Blue Sky Investments LLC · Fayetteville, NCBuilt 1967 · S/N 15068170 N22255Rodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 15068172 N22260Arnold James R · Latrobe, PABuilt 1967 · S/N 15068174 N22276Ramsey Lenny J · Greeneville, TNBuilt 1968 · S/N 15068185 N22277Gage Rodney L · Oak Grove, ARS/N 15068186 N22284Fenton Ted P · Rushville, MOS/N 15068191 N22285Barlow Richard B · Stockbridge, GABuilt 1968 · S/N 15068192 N22297Trissell Flying Service Inc. · Clarksville, TXBuilt 1968 · S/N 15068199 N222FDKent State University · Stow, OHBuilt 1968 · S/N 15068498 N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204 N22305Arend James E · Mesa, AZS/N 15068205 N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207 N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208 N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210 N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214 N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216 N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219 N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222 N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229 N22354Franks Cory · Idalou, TXS/N 15068232 N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233 N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236 N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237

Back to Cessna 150H