Lakewood, CO
Registered aircraft · 72
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 = 'LAKEWOOD' 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 = 'LAKEWOOD' 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.
N11636North American P-51D · S/N 45-11636NN1277XMooney M20E · S/N 150N1430RIndigo Skies RV 14(A) · S/N 140030N144MSSavino Michael RV-14A · S/N 140675N15ATLunacek Edward THATCHER CX4 · S/N 4441N16KCSpecht Stanley V KITFOX IV SPEEDSTER · S/N LCS151N184CTMoore Steven J TUKAN TRIKE · S/N 001N196CUniversal Stinson 108-2 · S/N 108-3196N201DPMooney M20J · S/N 24-0065N2038RCessna 182G · S/N 18255238N205UUMooney M20J · S/N 24-3067N2183VPiper PA-32RT-300T · S/N 32R-7987118N2209ECessna 172N · S/N 17271188N2392CCessna 180 · S/N 30692N24699Piper J4A · S/N 4-690N265DFFrey Darrell L SONEX · S/N 0265N2675TPiper PA-28-140 · S/N 28-7225084N271CKDiamond Aircraft Ind DA 40 NG · S/N 40.NC189N303PMDassault-Breguet FALCON 50 · S/N 103N305FWMooney M20J · S/N 24-1112First renewal noticeN3264ZPiper PA-22-150 · S/N 22-7213N32796Piper PA-28-235 · S/N 28-7510030N327SFPilatus PC-12/45 · S/N 511N328SFPilatus PC-12/45 · S/N 269N3334Paschke Stephen J ADVENTURER 333 · S/N 278634N356MTPiper PA-28-140 · S/N 28-21274N3777DCessna 182A · S/N 34477N3803CBell 205A-1 · S/N 30006N3804CBell 205A-1 · S/N 30314N3811CSikorsky S-70M · S/N 704113N38346Piper J3L-65 · S/N 6954N3941DCessna 182A · S/N 34641N3999BCameron Balloons US V-90 · S/N 5676N4032KNorth American NAVION A · S/N NAV-4-1032N411MZCessna 421C · S/N 421C1002N4274WAero SP Z O O AT-4 LSA · S/N AT4-013First renewal noticeN427SBKenneth Richard VAN'S RV-7 · S/N 70367N43887Taylorcraft BC12-D · S/N 7546Non-citizen corporation, flight hours not reportedN442HLRobinson Helicopter R44 II · S/N 11535First renewal noticeN444WPHonnecke-Bartling BUSHBY MUSTANG II · S/N M-II-340First renewal noticeN466BHWeaver Timothy J BEARHAWK 4 PLACE · S/N 466N4741XCessna U206G · S/N U20605529N4747Tl-Ultralight Sro STING S4 · S/N 11ST372First renewal noticeN5103XChampion 7KCAB · S/N 166N510BECessna 510 · S/N 510-0211N51430Maule M-4-210C · S/N 1097CN5225YCessna T182T · S/N T18208165N52714Cessna 182P · S/N 18262791N5359TCessna 172E · S/N 17251259N5563BCessna 182 · S/N 33563
Back to Lakewood, CO