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.

N60002Kirmeyer Dana L · Calhoun City, MSBuilt 1968 · S/N 15069998 N60016Meassick Steven F · Mount Horeb, WIBuilt 1968 · S/N 15070005 N60024Esker William D · White Mtn Lk, AZBuilt 1968 · S/N 15070011 N60026Lareaux Jon R · Calumet, MIBuilt 1968 · S/N 15070013 N60028Mesner Steven M · Tomah, WIBuilt 1968 · S/N 15070015 N6003260032 LLC · Jackson, MIBuilt 1968 · S/N 15070019 N60040Registration Pending · Cottage Grove, MNRegistration pendingBuilt 1968 · S/N 15070026 N60050Elsen Paul D · Winnebago, ILBuilt 1968 · S/N 15070035 N60052Onofre- Trejo Ray · Chicago, ILBuilt 1968 · S/N 15070037 N60056Jones Edward · Mechanicsburg, PABuilt 1968 · S/N 15070041 N60065Brewer Michael M · Naperville, ILS/N 15070048 N60067Kinsella Joseph R · Jackson, WYBuilt 1968 · S/N 15070050 N60069Moody Gary M · Osage, IABuilt 1968 · S/N 15070052 N60072Torres Guillen Jesus F · Gridley, CABuilt 1968 · S/N 15070054 N60074Barba John C · Missoula, MTBuilt 1968 · S/N 15070055 N60075Zaier Alan S · Saint Paul, MNBuilt 1968 · S/N 15070056 N60082Trinity Trust LLC · Fort Smith, ARBuilt 1968 · S/N 15070060 N60087Butcher David W · Radford, VABuilt 1968 · S/N 15070061 N60108Weakley Bobbi J · Chapmansboro, TNBuilt 1968 · S/N 15070074 N60115Leineke Brittan Dene · Orangevale, CABuilt 1968 · S/N 15070079 N60116Winglers Aviation LLC · San Ramon, CABuilt 1968 · S/N 15070080 N60119Hugo Emman P A · Livingston, TXBuilt 1968 · S/N 15070083 N60121Flight Tech Inc · Arlington, WAS/N 15070084 N60122Quintana Ortiz Nelson · Humacao, PRBuilt 1968 · S/N 15070085 N60123Long Jarod H · Satsuma, ALS/N 15070086 N60127Stagner Sanchez Viridiana · San Antonio, TXBuilt 1968 · S/N 15070090 N60128Harvey Timothy J · Cadott, WIBuilt 1968 · S/N 15070091 N60130Hoffman Matthew T · Topeka, KSS/N 15070093 N60138Clearwater Air & Auto Museum · Batavia, OHBuilt 1968 · S/N 15070099 N60139Jones John P · Great Meadows, NJBuilt 1968 · S/N 15070100 N60142Porter Herbert H · 100 Mile HouseBuilt 1968 · S/N 15070101 N60146Speer Henry A · Farmington, ARBuilt 1968 · S/N 15070103 N60160Iosco Flying Club · E Tawas, MIFirst renewal noticeBuilt 1968 · S/N 15070114 N60161Pipes George A II · Rolla, MOBuilt 1968 · S/N 15070115 N60163Metler Mark A · Summerville, SCBuilt 1968 · S/N 15070116 N60167Smith Kevin · Weaverville, NCBuilt 1968 · S/N 15070118 N60168Austin James H · Easley, SCBuilt 1968 · S/N 15070119 N60172Mchugh-Lemasteers Ronna · Salem, ORS/N 15070122 N60173Skypark Inc · Wadsworth, OHBuilt 1968 · S/N 15070123 N60174Pham Hieu · Goodyear, AZBuilt 1968 · S/N 15070124 N60175Strange William H · Lewiston, IDFirst renewal noticeBuilt 1968 · S/N 15070125 N60177Kelley Robert D · Barstow, CABuilt 1969 · S/N 15070126 N60179Steen Jason D · Clark, SDBuilt 1968 · S/N 15070127 N60183Hobbs Cody J · Omak, WAS/N 15070130 N60184Beaver Jason A · Reno, NVS/N 15070131 N60188N7010v LLC · Shelby, NCBuilt 1969 · S/N 15070134 N60191Vogt Jeffrey D · Pleasant Grove, CABuilt 1968 · S/N 15070136 N60203Mike Smith Aviation International Inc · Napa, CABuilt 1969 · S/N 15070142 N60205Garza Gilberto · Yuma, AZBuilt 1969 · S/N 15070144 N60215Yoder Johnathan · Thompson Falls, MTBuilt 1969 · S/N 15070149

Back to Cessna 150J