OpenAirDocs.org
Lafayette, CO

Registered aircraft · 40

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 = 'LAFAYETTE'
  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.

N141FWWatson Francis W RV-6A · S/N 22898Built 2011 · Schultz Frank RN1537EAeronca 7AC · S/N 7AC-5100Built 1946 · Hammerdog LLCN172AMCessna 172M · S/N 17264993Built 1975 · Yang ChiN1866KSilvaire LUSCOMBE 8 · S/N 4593Built 1947 · Heckman Kyle JN195DLTracy Dennis E TRACY VANS RV-6 · S/N 22996Built 2001 · Tracy Dennis EN19KYBeech E-55 · S/N TE-1073Chi YangN201MPMooney M20J · S/N 24-0072Built 1977 · Hamre AustinN233FAviat A-1B · S/N 2330Cjk IncN2553QCessna 182K · S/N 18257753Built 1966 · Sanders William R JrN2734HCessna 182B · S/N 52034Built 1959 · Griebel Kyle LN2860CPiper PA-28-201T · S/N 28-7921074N2860c LLCN341RAS.O.C.A.T.A. RALLYE 235E · S/N 13118Built 1978 · Yang ChiN358TDIsrael Aircraft Industries GULFSTREAM 200 · S/N 170Built 2007 · Yang ChiN3660NPiper PA-12 · S/N 12-1909Jinnette Michael EN39KYPiper PA-44-180 · S/N 447995304Built 1979 · Yang ChiN3JVSchempp-Hirth K. G NIMBUS II · S/N 13Built 1972 · Ad Nimbus LLCN419LDSteve Dentz CCK-1865 · S/N CCK-1865-0084Built 2015 · Adamant Hangars LLCN42101Beech 95-B55 · S/N TC-1292Built 1970 · Ross EvanN480PGCirrus Design SR20 · S/N 1887Built 2008 · Yang ChiN482CGCessna T182T · S/N T18208438Built 2005 · Kilo Sierra Enterprises LLCN483PGCirrus Design SR20 · S/N 1895Built 2008 · Yang ChiN5045BBeech F35 · S/N D-4323Chi YangN5187HPiper PA-14 · S/N 14-505Jinnette Michael EN555VGCirrus Design SR22 · S/N 3701Built 2010 · Cordingley RobertN617BWilliams Fred RV-10 · S/N 40515Built 2008 · Mchugh Ryan SN6422RPiper PA-28-140 · S/N 28-21601Built 1966 · Yang ChiN652DBBeech F33A · S/N CE-1144Built 1987 · Rocky Mountain Air LLCN655ASChris Wallen JA35 SUPERSTOL · S/N JA493-06-16Built 2017 · Smith Ackley CN65BCAlexander Schleicher ASH 31 MI · S/N 31146Built 2016 · Caldwell Robert JN660PCClaar Patrick S RV-6 · S/N 20925Built 1996 · Obrien Kenneth JN66BCGame Composites GB1 GAMEBIRD · S/N 0066Built 2023 · Caldwell Aviation 303 LLCN701TNSimpson J/Simpson R CH701 · S/N 7-6416Built 2012 · Hammerdog LLCN7259XCessna 150B · S/N 15059359Built 1961 · Redtail LLCN7635HPiper PA-12 · S/N 12-510Built 1946 · Obrien Kenneth JN8372KRobinson Helicopter R44 · S/N 1099Built 2001 · Yang ChiN8551DAerofab LAKE 250 · S/N 125Cordingley Robert L IIN87009Bellanca 7KCAB · S/N 449-74Built 1974 · Wrench HeathN889CALearjet 45 · S/N 132Built 2001 · Gracon Express LLCN96706Cirrus Design SR20 · S/N 1116Built 2001 · Cordingley Robert LeeN984DSCessna T310R · S/N 310R0622Wilger Thomas J
Back to Lafayette, CO