Skip to content

Registered aircraft · 1,065

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

N8344GDonat Brandon L · Glendale, AZS/N 15062444 N8346GN8346g LLC · Fort Pierce, FLBuilt 1965 · S/N 15062446 N8347GKeyes Mitchell R · Cornelius, NCBuilt 1965 · S/N 15062447 N8353GHove Jeffrey P · Saint Paul, MNBuilt 1965 · S/N 15062453 N8355GGrant Jimmy L · Ada, OKBuilt 1965 · S/N 15062455 N8365GMendez Carlos L · Somerset, NJBuilt 1965 · S/N 15062465 N8366GRovers Adrian J · Chazy, NYBuilt 1965 · S/N 15062466 N8367GRangesh Abinand · Newton, MABuilt 1965 · S/N 15062467 N8368GClark Jeffrey S · Knoxville, TNBuilt 1965 · S/N 15062468 N8370GCarter Edward D · Ethel, MOBuilt 1965 · S/N 15062470 N8373GColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1965 · S/N 15062473 N8382GArneson Kenneth W · Beaverton, ORS/N 15062482 N8384GWoodall Steve W · Penngrove, CABuilt 1965 · S/N 15062484 N8386GIndy Hot Air LLC · Westfield, INBuilt 1965 · S/N 15062486 N8387GAir Land And Sea Adventures LLC · West Palm Beach, FLBuilt 1965 · S/N 15062487 N838HPKeathley Jeremie L · Rolla, MOBuilt 1966 · S/N 15062786 N8391GReynolds Timothy D · Locust Grove, GABuilt 1965 · S/N 15062491 N8392GSander Clay O · Mutual, OKBuilt 1965 · S/N 15062492 N8395GSmith David B · Indianapolis, INS/N 15062495 N8396GBarnes Greg B · Tunas, MOBuilt 1965 · S/N 15062496 N8400BEdwards R Deryl · Joplin, MOS/N 15062500 N8409GOberholzer Craig C · Stanley, NCS/N 15062509 N8412GMiller Charles V · High Point, NCBuilt 1965 · S/N 15062512 N8414GKendallville Flying Service Inc · Saint Joe, INBuilt 1965 · S/N 15062514 N8416GMetrovich Paul A · Wellsville, OHBuilt 1965 · S/N 15062516 N8418GBravo Charlie Global LLC · Kalispell, MTBuilt 1965 · S/N 15062518 N8423GCamp Derek E · Sweetwater, TNBuilt 1965 · S/N 15062523 N8428GTrainor Ty Anthony · Sneads Ferry, NCBuilt 1965 · S/N 15062528 N8431GNordstrom Marc A · Bend, ORS/N 15062531 N8442GFoster Dustin · Dublin, VAS/N 15062542 N8443GVon Wald Enterprises LLC · Glendale, AZBuilt 1965 · S/N 15062543 N8448GMidwest Aviation Services LLC · Kendallville, INBuilt 1965 · S/N 15062548 N8453GBelue Gaythan D · Rogersville, ALBuilt 1965 · S/N 15062553 N8456GAerial Perspective Inc · Fullerton, CABuilt 1965 · S/N 15062556 N8461GColbert Donald H · Tonasket, WABuilt 1966 · S/N 15062561 N8464GWhite Sands Soaring Association Inc · Alamogordo, NMBuilt 1965 · S/N 15062564 N8465GBeltz Darren S · Mattawan, MIBuilt 1965 · S/N 15062565 N8472GDirk Chantz M · Rapid City, SDBuilt 1966 · S/N 15062572 N8478GTaylor Scott G · Draper, UTS/N 15062578 N8479GRoscoe J Chandler · Midlothian, TXS/N 15062579 N8480GMatthews Scott R · Baker City, ORS/N 15062580 N8485GWhipple James M · Wadsworth, OHS/N 15062585 N8490GDodot Daniel A · Westminster, COS/N 15062590 N8491GMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 15062591 N8494GReynolds Terry J · Phoenix, AZBuilt 1965 · S/N 15062594 N8495GCorrigan John P · Denver, COBuilt 1965 · S/N 15062595 N8497GDeacon Jeffrey A · Battle Ground, WABuilt 1965 · S/N 15062597 N8499GRyan Richard E · Atlantic, IABuilt 1965 · S/N 15062599 N8500GAugust Mark C · Atchison, KSBuilt 1965 · S/N 15062600 N8503GPynn David W · Gasport, NYBuilt 1965 · S/N 15062603

Back to Cessna 150F