OpenAirDocs.org
Crawford, CO

Registered aircraft · 29

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 = 'CO' AND g.registrant_city = 'CRAWFORD'
  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.

N10362Schweizer SGU 2-22C · S/N 87Pursuit-Air-Crafters LLCN103BJJudy Louis JUDY FAST ONE · S/N 1Built 1998 · Kempf Randall PN105AACessna R182 · S/N R18200483Built 1978 · Wehrmacher James PN14ACMooney M20R · S/N 29-0117Built 1997 · Lippert Bradley WN186FCcx0119 CCX-2000 · S/N CCX-2000-0119Built 2021 · Ccx0119 LLCN193ACAmerican Champion 8GCBC · S/N 365-93Built 1993 · Stearman Aviation IncN204NCcx0119 CCX-2000 · S/N CCX-2000-0204Registration pendingBuilt 2024N2070SCessna T210L · S/N 21061037Built 1975 · Thompson Robert V TrusteeN2849DWaco AQC-6 · S/N 5037Stearman Aviation IncN305FCessna 182F · S/N 18254903Built 1963 · Stockdale Aviation LLCN39TMAlisport SILENT 2 ELECTRO · S/N 2087Built 2017 · Ledford James DN3XHSmith Rodney S BEARHAWK · S/N 246Built 2024 · Smith Rodney SN43453Butterfield Thomas BUTTERFIELD 2000 · S/N H2-04-15-624Ra Ventures LLCN43RARobert W Duncan AR-1 · S/N 0055Built 2022 · Ra Ventures LLCN4447DPiper PA-28-235 · S/N 28-10621Wehmacher James PN4574NBeech D17S · S/N 6727Built 1944 · Stearman Aviation IncN45TWCameron Clark S JA30 SUPERSTOL · S/N JA512-11-17Built 2021 · Cameron Clark SN55670Boeing A75N1(PT17) · S/N 75-2378Built 1941 · Stearman Aviation IncN6362PPiper PA-24-250 · S/N 241581Built 1959 · Stearman Aviation IncN6385TSchleicher Alexander K 7 · S/N 7014Built 1962 · Crawford Soaring IncN6674NTaylorcraft 20 · S/N 20028Built 1956 · Stearman Aviation IncN69HHHaigh Henry A HAIGH SPECIAL · S/N 69First renewal noticeBuilt 1994 · Taylor Kent MN714KWCessna 150M · S/N 15079243Built 1977 · Herbert Michael SN745FWCessna 152 · S/N 15283905Built 1980 · Walther Frank CN747FWAir Creation GTA · S/N 2536Built 1995 · Walther Frank CN7915ATaylorcraft 15A · S/N 5-14005Built 1953 · Stearman Aviation IncN802DLM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD208Registration pendingBuilt 2024N8BPNorth American/Victoria MNT LT AT-6A · S/N 66-2517Built 1942 · Kempf Douglas AN90860Let BLANIK L-13 · S/N 025716Built 1973 · Stearman Aviation Inc
Back to Crawford, CO