Fishers, IN
Registered aircraft · 125
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 = 'IN' AND g.registrant_city = 'FISHERS' 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 = 'IN' AND g.registrant_city = 'FISHERS' 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.
N4664JPiper PA-28R-180 · S/N 28R-30562N46VEBombardier BD-100-1A10 · S/N 20396N479SLMichael Stenger SKYLITE · S/N SSL-479N502DJCameron Balloons US M-34 · S/N 6325N506FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252289N507FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252251N508FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252290N509FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252291N510FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252292N5125VMorrisey 2150A · S/N SP-21N5168VCessna 172S · S/N 172S9037N525BPCessna 525 · S/N 525-0479N5281KAerostar International RX 8 · S/N RX8-3327N5294QAerostar International RX 8 · S/N RX8-3347N53475Cessna 337G · S/N 33701649N5640KBeech S35 · S/N D-7397N573JAPiper PA-28-181 · S/N 28020264N58UMUltramagic M-130 · S/N 130/117N6008DBeech C24R · S/N MC-611N6022EBeech K35 · S/N D-5930N60KQQuest KODIAK 100 · S/N 100-0060N611MRCessna 560XL · S/N 560-5514N6146FCessna A150L · S/N A1500427N614ACAmerican Champion 7GCAA · S/N 454-2001N615LBLindstrand Balloons 105A · S/N 5539N617JAPiper PA-28-181 · S/N 28020265N629PNRVB Baloes SS-25-EL · S/N MAB 2012126N6320DJI AGRAS T40 · S/N 64TBKBC0020020N635BDPiper PA-32R-300 · S/N 32R-7680233N641FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20242284N642FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20242285N6431QMooney M20F · S/N 670510N643FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252286N644FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252287N645FBEvektor-Aerotechnik A S HARMONY LSA · S/N 20252288N647MAPiper PA-28-181 · S/N 28020267N650FMFrank Moseley Jr/David Ferrell ZODIAC CH 650 · S/N 65-8616N6560DJI AGRAS T40 · S/N 64TBKAF00200E4N658CCPiper PA-28-181 · S/N 2881919N668CSTextron 172S · S/N 172S11667N708JAPiper PA-28-181 · S/N 28020263N7150UAerostar International RX 8 · S/N RX8-3249N716CDCirrus Design SR22 · S/N 0039N719PMP & M PEGASUS QUIK · S/N 8248N721ZACessna 182T · S/N 18281439N72BFFrazier Ben RV7A · S/N 72211N72JACessna 414A · S/N 414A0333N72SFCollette William R VANS RV-4 · S/N 3053N735GUCessna 182Q · S/N 18265420N758PECessna R172K · S/N R1723245
Back to Fishers, IN