Woodbury, MN
Registered aircraft · 27
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 = 'MN' AND g.registrant_city = 'WOODBURY' 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 = 'MN' AND g.registrant_city = 'WOODBURY' 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.
N11LJCessna T206H · S/N T20608485N145HPAviat A-1B · S/N NF0006N16DYYounggren Darell W KR2 S · S/N 8861 KR2S 203N17453Waco YKS-7 · S/N 4554N17726Beech 95-B55 (T42A) · S/N TC-2046N2003CTaylorcraft F19 · S/N F-147N201KLMooney M20J · S/N 24-0452N232PMInterplane XJ · S/N 3543N241PAAviat A-1C-180 · S/N 3069N247CTCessna 320 · S/N 320-0058N336WBDiamond Aircraft Ind DA 40 NG · S/N 40.N535N351TBSocata TB-20 TRINIDAD · S/N 1708N39JTTurner Jeffrey L RV-14 · S/N 140546N5103TChampion 7ECA · S/N 441N602DTPiper PA-28-236 · S/N 28-8011118N612EFVans RV-12IS · S/N 121026N61475Preceptor/Gethmann Will N-3 PUP · S/N 051503N70323Cessna 172M · S/N 17267200N704QMCessna 150M · S/N 15078790N755CPCirrus Design SR22 · S/N 3174N790LTDassault-Breguet MYSTERE FALCON 900 · S/N 129N7SZMichael Mathew Giardino LANCAIR L-IV · S/N L-IV 259N8173ECessna 172N · S/N 17272147N8341CCessna 525 · S/N 525-0150N88204Piper J3C-65 · S/N 15821N95969Taylorcraft BC12-D · S/N 8269N97916Stinson 108-1 · S/N 108-1-916
Back to Woodbury, MN