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.
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
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.
N1203FCessna 172N · S/N 17272968N120SESpringer Jerry W RAGTIME PARRAKEET · S/N JS1-100N125JKKearbey Jack C EMERAUDE · S/N 1163N13RSShindler-Robert MEADOW LARK · S/N RES-2N1424DCessna 170A · S/N 20136N15373Piper PA-28-140 · S/N 28-7325051N1579APiper PA-20 · S/N 20-813N1626NFunk B85C · S/N 406N164WPPendergrass Benjamin Daniel RV6 · S/N 25460N179CTFlight Design CTLS · S/N F-08-07-05N18210Cessna 150L · S/N 15073865N1975JHarper Donald D RANS S-6ES · S/N 0496982ESN2020NCessna 140 · S/N 12256N225ACrouch Sowers Special CS-1 · S/N 1N22986Piper J3F-50 · S/N 2887N23602Taylorcraft BL-65 · S/N 1326N240LCColtharp Sherrod L RANS S-6S · S/N 09051693Registration pending, canceledN2657BAero Commander 560 · S/N 157N288RVEdgar A Edwards RV8A · S/N 83535N29432Cessna 177 · S/N 17700883N29619Cessna 177 · S/N 17700996N299JBBohannon James A JR RV-6 · S/N 21334N31750Awad Ronald Edward JR RAD02 · S/N 001N31CJCessna 525 · S/N 525-0474N3326GNorth American AT-6D · S/N 43846N3400KPiper J3C-65 · S/N 22091N3440VCessna 190 · S/N 7144N3503ZPiper PA-22-150 · S/N 22-7398N3531Reese Starduster Too SA-300 · S/N 198N3550PPiper PA-22-150 · S/N 22-3306N3556PPiper PA-22-150 · S/N 22-3312N3580NPiper J3C-65 · S/N 22821N3638KPiper J3C-65 · S/N 22329N3723JCessna 150G · S/N 15065023N3806VCessna R172K · S/N R1722263N38640Piper J5A · S/N 5-1025N38BBallew James PIETENPOL-JB ARCMPER · S/N 10N3904QCessna 172L · S/N 17260004N40988Piper J4E · S/N 4-1610N4307RCessna 172M · S/N 17263060N4374BChouinard Shawn A VANS RV-10 · S/N 42279N4374KChouinard Shawn A VANS RV-10 · S/N 41626N4442NBoeing A75N1(PT17) · S/N 75-7893N4555DGulfstream American AA-5B · S/N AA5B1214N471CBTextron 680 · S/N 680-0576N4935NBoeing A75N1(PT17) · S/N 75-2087N4977ZPiper PA-22-108 · S/N 22-8583N49CSSawka Craig S CHRISTEN EAGLE-II · S/N SAWKA 0001N5334TCessna 172E · S/N 17251234N540TDExtra Flugzeugbau EA 300/L · S/N 059
Back to Collinsville, OK