Collinsville, OK

Registered aircraft · 101

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'OK' AND g.registrant_city = 'COLLINSVILLE'
  ORDER BY g.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.

N1203FCessna 172N · S/N 17272968Built 1979 · Rawson Aviation LLCN120SESpringer Jerry W RAGTIME PARRAKEET · S/N JS1-100Built 1990 · Barrientos Jeri DN125JKKearbey Jack C EMERAUDE · S/N 1163Built 1993 · Kearbey Jack CN13RSShindler-Robert MEADOW LARK · S/N RES-2Howard Kenneth LN1424DCessna 170A · S/N 20136Built 1951 · N1424d LLCN15373Piper PA-28-140 · S/N 28-7325051Johnson Brant TN1579APiper PA-20 · S/N 20-813Built 1951 · Delap JayN1626NFunk B85C · S/N 406Howard Kenneth LN164WPPendergrass Benjamin Daniel RV6 · S/N 25460Pendergrass Benjamin DN179CTFlight Design CTLS · S/N F-08-07-05Built 2008 · Mcmath PeggyN18210Cessna 150L · S/N 15073865Built 1972 · Aircraft Construction Specialist IncN1975JHarper Donald D RANS S-6ES · S/N 0496982ESBuilt 1998 · Cooper William PN2020NCessna 140 · S/N 12256Built 1947 · Hair Cory AN225ACrouch Sowers Special CS-1 · S/N 1Built 1953 · Delap Jay CN22986Piper J3F-50 · S/N 2887212 Investments LLCN23602Taylorcraft BL-65 · S/N 1326Built 1939 · Gerber D M JrN240LCColtharp Sherrod L RANS S-6S · S/N 09051693Registration pending, canceledBuilt 2007N2657BAero Commander 560 · S/N 157Hughes Coby DN288RVEdgar A Edwards RV8A · S/N 83535Barrientos Jeri DN29432Cessna 177 · S/N 17700883Built 1968 · Waddell Bhrent E TrusteeN29619Cessna 177 · S/N 17700996Built 1968 · Loudenslager Donald FN299JBBohannon James A JR RV-6 · S/N 21334Built 2002 · Shelton Greg N TrusteeN31750Awad Ronald Edward JR RAD02 · S/N 001Yeats Chris PN31CJCessna 525 · S/N 525-0474Built 2001 · 212 Investments Of Montana LLCN3326GNorth American AT-6D · S/N 43846Built 1943 · Shelton Greg N TrusteeN3400KPiper J3C-65 · S/N 22091Built 1946 · Forbes Bruce RN3440VCessna 190 · S/N 7144Built 1948 · Barrientos Jeri DN3503ZPiper PA-22-150 · S/N 22-7398Built 1960 · Mcmath DonN3531Reese Starduster Too SA-300 · S/N 198Built 1970 · Lippert Mark SN3550PPiper PA-22-150 · S/N 22-3306Built 1955 · Yates Darren LN3556PPiper PA-22-150 · S/N 22-3312Built 1955 · Planes & Things IncN3580NPiper J3C-65 · S/N 22821Built 1947 · Schoeler George AN3638KPiper J3C-65 · S/N 22329Built 1946 · Shelton Greg N TrusteeN3723JCessna 150G · S/N 15065023Built 1966 · Kerns Kenneth EN3806VCessna R172K · S/N R1722263Built 1977 · Shirey Donnie WN38640Piper J5A · S/N 5-1025Built 1941 · Mccutchan Anthony LN38BBallew James PIETENPOL-JB ARCMPER · S/N 10Built 1995 · Ballew James WN3904QCessna 172L · S/N 17260004Built 1971 · Kern Bruce AN40988Piper J4E · S/N 4-1610Built 1941 · Barrientos Jeri DN4307RCessna 172M · S/N 17263060Built 1974 · Mcmath DonN4374BChouinard Shawn A VANS RV-10 · S/N 42279Built 2026 · Chouinard Shawn AN4374KChouinard Shawn A VANS RV-10 · S/N 41626Built 2022 · Chouinard Shawn AN4442NBoeing A75N1(PT17) · S/N 75-7893Built 1943 · Shelton Greg TrusteeN4555DGulfstream American AA-5B · S/N AA5B1214Tiny Tiger Aircraft IncN471CBTextron 680 · S/N 680-0576Built 2017 · 888tn LLCN4935NBoeing A75N1(PT17) · S/N 75-2087Built 1941 · Hughes Consolidated IncN4977ZPiper PA-22-108 · S/N 22-8583Mcdorman JoshuaN49CSSawka Craig S CHRISTEN EAGLE-II · S/N SAWKA 0001Built 1980 · Doherty Sean MN5334TCessna 172E · S/N 17251234Built 1964 · Barker Charles W JrN540TDExtra Flugzeugbau EA 300/L · S/N 059Fitzgerald Craig A
Back to Collinsville, OK