Loveland, CO
Registered aircraft · 135
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 = 'LOVELAND' 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 = 'CO' AND g.registrant_city = 'LOVELAND' 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.
N102LGGagnon Laurent J KITFOX IV 1200 · S/N 1745N105PFArbc Inc DBA Lindstrand 105A · S/N 5282N10621Cessna 150L · S/N 15074930N1073VUltramagic S-90 · S/N 90/133N1121TCessna 182L · S/N 18258703N113MSAmerican Champion 7GCBC · S/N 1217-96N118FSCessna 172R · S/N 17281198N119NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC180N121GKKurtz Garold RV4 · S/N 2767N121NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC100N122SDShari L Vines VSD2 · S/N 122806N125SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1311N133EJGates Learjet 35A · S/N 133N148HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-16-229N15200Piper PA-28-235 · S/N 28-7310020N15SGStump Clarence H JR BABY LAKES · S/N 7723-H-674BN162DKWilliams David C ROTORWAY 162F · S/N 001N199BWGame Composites GB1 GAMEBIRD · S/N 0079N2112JLuce Matt A CLASSIC 4 · S/N C 9409 0058N216EEBerkram Daniel A RV-9A · S/N 91187N21CJCorey Jones RANS S21 OUTBOUND · S/N 11220301N227PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC247N2306XXag P100 PRO · S/N 8219314246HMN231CUXag P100 PRO · S/N 1863FPEG8219314A8X26N2383NCessna 120 · S/N 12632N2462WPowrachute AIRWOLF 912ULS · S/N A235ULSN246BWBellanca 17-30A · S/N 79-30930N254PNDJI AGRAS T30 · S/N 3TNDJ6900210U8N262KBBell 407 · S/N 53380N2641ZCessna 310R · S/N 310R1804N265HBHill-Cannon SORRELL SNS-7 · S/N 265N266SPCessna 172S · S/N 172S9471N2680EBreen Charles GT 400 · S/N Q0703N282DPGame Composites GB1 GAMEBIRD · S/N 0120N291DNXag P100 PRO · S/N 1863FPEG82193434UN69N297QNXag P100 PRO · S/N 1863FPEG82193430J69JN2993NXag P100 PRO · S/N 1863FPEG82193432XP29N29AGCessna 680 · S/N 680-0100N29LNIsrael Aircraft Industries 1124A · S/N 389N307CMEpic E1000 · S/N K042N3172KBeech A36 · S/N E-2435N325SPCessna 172S · S/N 172S8251N327CVCopley Joe VELOCITY 173 LW FG-E · S/N DMO-327N3395CBeech F35 · S/N D-4062N33HPBeech 35-C33 · S/N CD-939N345RZDJI AGRAS T30 · S/N 3U5BJ6M001000JN363CHCharles A Hautamaki SPORTSMAN · S/N 7411N3744NDehavilland TIGER MOTH DH 82A · S/N 4415N3927PPiper PA-22-150 · S/N 22-3600N4005CUniversal Stinson 108-3 · S/N 1084005
Back to Loveland, CO