Skip to content

Registered aircraft · 659

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

N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347 N50502Behnke Randall · Manitowoc, WIS/N 15069351 N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352 N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376 N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377 N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378 N50535Harrell Lewis H · Pontotoc, MSS/N 15069380 N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382 N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384 N50544Kidd Ronnie E · Ramseur, NCS/N 15069386 N50550Registered aircraftS/N 15069391 N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392 N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396 N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405 N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408 N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409 N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411 N50581Pritchett Otis R · Avery, TXS/N 15069412 N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414 N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423 N50606Siderwicz Christopher J · Marstons Mills, MABuilt 1968 · S/N 15069429 N50610Henry Mark Alan · Dickinson, TXS/N 15069431 N50614Walker William G Jr · Scottsdale, AZBuilt 1968 · S/N 15069434 N50617Adventist World Aviation · Wilson, NCS/N 15069436 N50618Clark Christopher W · Fallon, NVBuilt 1968 · S/N 15069437 N50621Slade Michael · Lakeville, MABuilt 1968 · S/N 15069439 N50624Davis Clint A · Fairland, INBuilt 1968 · S/N 15069442 N50628Padgett Justin S · Fruithurst, ALBuilt 1968 · S/N 15069445 N50629Boshart Stanley J · Albany, ORBuilt 1968 · S/N 15069446 N50633Sherwood Ronald R · Kathleen, GABuilt 1968 · S/N 15069449 N50641Jstram Lc · Sheridan, WYBuilt 1968 · S/N 15069454 N50652Omlid Robert L · Watford City, NDBuilt 1968 · S/N 15069461 N50663Zimna Grazyna · KrasocinS/N 15069467 N50665Meneely Robert W · Los Altos Hills, CAS/N 15069469 N50672Registered aircraftBuilt 1968 · S/N 15069476 N50679Go Fly Ez LLC · Athens, OHBuilt 1968 · S/N 15069480 N50688Hershey Andrew C · Manchester, NHBuilt 1968 · S/N 15069485 N50691Layka'S Choice LLC · Lawrenceville, GABuilt 1968 · S/N 15069487 N50695Mannfolk Steven M · Wingdale, NYS/N 15069489 N50696Winsor Andrew · Medford, MAS/N 15069490 N50697Cole Timothy Les · Las Vegas, NVBuilt 1968 · S/N 15069491 N50704Fox Valley Technical College · Oshkosh, WIBuilt 1968 · S/N 15069496 N50706Rhoades Charles E · Blessing, TXFirst renewal noticeS/N 15069498 N50717Road Robert L · Fargo, NDBuilt 1968 · S/N 15069504 N50720Smith Bruce Allan · Phelps, KYBuilt 1968 · S/N 15069506 N50728Erickson Aeronautics LLC · Perry, IABuilt 1968 · S/N 15069512 N50729Blue Sky 6 LLC · Torrance, CAS/N 15069513 N50732Lil 150 LLC · Sauk Rapids, MNBuilt 1968 · S/N 15069515 N50734Dillman Kurt A · Victor, NYBuilt 1968 · S/N 15069517 N50745Caicedo David · Villa Rica, GABuilt 1968 · S/N 15069524

Back to Cessna 150J