Florida Institute Of Technology
Registered aircraft · 40
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'FLORIDA INSTITUTE OF TECHNOLOGY' OR list_contains(g.other_registrant_names, 'FLORIDA INSTITUTE OF TECHNOLOGY') 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_name = 'FLORIDA INSTITUTE OF TECHNOLOGY' OR list_contains(g.other_registrant_names, 'FLORIDA INSTITUTE OF TECHNOLOGY') 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.
N131RAAmerican Champion 7ECA · S/N 1389-2003N602FTPiper PA-28-161 · S/N 28-7716056N603FTPiper PA-28-161 · S/N 28-7916427N604FTPiper PA-28-161 · S/N 28-8516078N607FTPiper PA-28-161 · S/N 28-7916271N608FTPiper PA-28-161 · S/N 28-7916328N609FTPiper PA-28-161 · S/N 28-7716270N612FTPiper PA-28-161 · S/N 28-7816197N615FTPiper PA-28-161 · S/N 28-8116123N618FTPiper PA-28-161 · S/N 28-8516048N621FTPiper PA-28-161 · S/N 28-8416124N623FTPiper PA-28-161 · S/N 28-7816131N624FTPiper PA-28-161 · S/N 28-7916446N625FTPiper PA-28-161 · S/N 2842130N627FTPiper PA-28-161 · S/N 2842131N628FTPiper PA-28-161 · S/N 2842124N629FTPiper PA-28-161 · S/N 2842132N631FTPiper PA-28-161 · S/N 28-8216036N635FTPiper PA-28-161 · S/N 2842311N636FTPiper PA-28-161 · S/N 2842310N637FTPiper PA-28-161 · S/N 2842314N638FTPiper PA-28-161 · S/N 2842315N639FTPiper PA-28-161 · S/N 2842316N640FTPiper PA-28-161 · S/N 2842317N641FTPiper PA-28-161 · S/N 2842318N642FTPiper PA-28-161 · S/N 2842319N643FTPiper PA-28-181 · S/N 2843703N644FTPiper PA-28-181 · S/N 2843704N645FTPiper PA-28-181 · S/N 2843705N646FTPiper PA-28-181 · S/N 2843706N647FTPiper PA-28-181 · S/N 2843707N648FTPiper PA-28-181 · S/N 2843708N649FTPiper PA-28-181 · S/N 2843709N650FTPiper PA-28-181 · S/N 2843710N880FTPiper PA-44-180 · S/N 4496033N880HMPipistrel D O O VIRUS SW 128 · S/N VSWX1280032N881FTPiper PA-44-180 · S/N 4496235N882FTPiper PA-44-180 · S/N 4496248N884FTPiper PA-44-180 · S/N 4496250N885FTNew Piper PA-44-180 · S/N 4496225
Back to Florida Institute Of Technology