Oskaloosa, IA
Registered aircraft · 18
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 = 'IA' AND g.registrant_city = 'OSKALOOSA' 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 = 'IA' AND g.registrant_city = 'OSKALOOSA' 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.
N104EZDJI AGRAS T50 · S/N 1581F6BUB243P00118L1N110WAGulfstream Aerospace GIV-X (G450) · S/N 4179N164SMMineart Stephen M ZODIAC CH601XL · S/N 6-5109N335XADJI AGRAS T30 · S/N 3TNDJ48002Y56NN347AVHull James S AVID FLYER HVY HLR · S/N 1007N3523FPowrachute PEGASUS · S/N A405 PEGN36617Aeronca 65-LB · S/N LB16931N4012DCessna 182A · S/N 34712N44090Taylorcraft BC12-D · S/N 9890N543MBDJI AGRAS T50 · S/N 1581F6BUB249F001278XN59SGGivens Steve TCLIPS · S/N T01N6010DPiper PA-22-150 · S/N 22-4662N76806Cessna 120 · S/N 11238N80459Kolb PPC · S/N A01PCN804BHRaytheon HAWKER 800XP · S/N 258596N8670UCessna 172F · S/N 17252573N95104Taylorcraft BC12-D · S/N 9504N97256Stinson 108 · S/N 108-256
Back to Oskaloosa, IA