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.

N60628Aukeman Mark C · Georgetown, MEBuilt 1969 · S/N 15070460 N60630Bichell Kevin C · Corsicana, TXBuilt 1969 · S/N 15070461 N60632Lawlyes Bill · Aguanga, CABuilt 1969 · S/N 15070463 N60633Newby Terry · Kokomo, INBuilt 1969 · S/N 15070464 N60639International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15070468 N60640Lazarus Benjamin · Blaine, WAS/N 15070469 N60641Motory Group LLC · Alachua, FLBuilt 1969 · S/N 15070470 N60649Anglin Cheryl L · Jackson, MSFirst renewal noticeBuilt 1969 · S/N 15070477 N60650St Arneault Carmen M · Milton, NHBuilt 1969 · S/N 15070478 N60652Broughton Stanley K · Salt Lick, KYBuilt 1969 · S/N 15070479 N60653Russo Joseph M · Pleasant Grove, CABuilt 1969 · S/N 15070480 N60672Johnson Jeffry L · Eufaula, OKS/N 15070491 N60681Hendrickson Robert T · Galesburg, ILS/N 15070496 N60682Sweeney Andrew H · Murray, KYBuilt 1969 · S/N 15070497 N60684Gunnarsson Elliott Gudni · Concrete, WABuilt 1969 · S/N 15070499 N60685Barton Steven Lewis · Ventura, CABuilt 1969 · S/N 15070500 N60687Luse Benjamin T · Newalla, OKBuilt 1969 · S/N 15070501 N60693Conaway David J · Orange Park, FLBuilt 1969 · S/N 15070506 N60694Hodgkinson David · Tolland, CTBuilt 1969 · S/N 15070507 N60701Nichols Daniel H · Helen, GAFirst renewal noticeBuilt 1969 · S/N 15070511 N60704Discover Aviation LLC · Unionville, MOS/N 15070512 N60708Registration Pending · Wentworth, MORegistration pendingS/N 15070515 N60714Yoder Frederick David · Wellington, FLBuilt 1969 · S/N 15070520 N60716Evans Michael J · Greenville, MIBuilt 1969 · S/N 15070522 N60720Sedlak Christopher T · Lake City, FLBuilt 1969 · S/N 15070526 N60725Mcghie Kraig J · Sterling, AKS/N 15070527 N60729Parry Peter S · New Kent, VABuilt 1969 · S/N 15070530 N60735Ozarks Technical Community College · Springfield, MOBuilt 1969 · S/N 15070535 N60738Long William E · Old Town, FLBuilt 1969 · S/N 15070537 N60742Greene Daniel W · Somerton, AZBuilt 1969 · S/N 15070539 N60743Cowart Frederic D · Baytown, TXBuilt 1969 · S/N 15070540 N60748Flawless Aviation LLC · Loxahatchee, FLS/N 15070544 N60749Frazier Brian D · Jackson, MSBuilt 1969 · S/N 15070545 N60756Vanjara Obaid U · San Ramon, CABuilt 1969 · S/N 15070551 N60757Follman Aviation LLC · Waterport, NYBuilt 1969 · S/N 15070552 N60761Code 1 Flight Training LLC · Canton, TXS/N 15070556 N60767Turnier Mikel W · Middletown, NYBuilt 1969 · S/N 15070561 N60769Del Duca Frank J · Bethel, MEBuilt 1969 · S/N 15070563 N60773Edwards Air LLC DBA · Raleigh, NCBuilt 1969 · S/N 15070566 N60781Two Birds One Bear LLC · Upper Arlington, OHBuilt 1969 · S/N 15070574 N60787Kenses Daniel T · Stuart, FLBuilt 1969 · S/N 15070579 N60790Jenkins Berry E · Bell, FLBuilt 1969 · S/N 15070581 N60793Registered aircraftBuilt 1969 · S/N 15070584 N60796Lemanski Thomas A · Port Townsend, WABuilt 1969 · S/N 15070585 N60797Portland Metro Aviation & Flying Club · Portland, ORBuilt 1969 · S/N 15070586 N60798Hjl Farm Inc · Dagmar, MTS/N 15070587 N60800Edens Harald E · Socorro, NMBuilt 1969 · S/N 15070588 N60802Smith Jay · San Andreas, CAS/N 15070590 N60808Foster William L · Waco, TXS/N 15070592 N60818Bailey James C · Drummond Island, MIBuilt 1969 · S/N 15070597

Back to Cessna 150J