Molino, FL
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 = 'FL' AND g.registrant_city = 'MOLINO' 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 = 'FL' AND g.registrant_city = 'MOLINO' 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.
N108NGDiamond Aircraft Ind DA 42 NG · S/N 42.N172N11950Cessna 177B · S/N 17702382N1718Fritts Dofin Allen 532 COMMANDER ELITE · S/N 001N1718BFritts Dofin Allen R A F 2000 · S/N H2-94-5-138N2503WHill Herb RAF 2000 GTX SE FCT · S/N H2-02-13-543N2521FFritts Dofin 2000 GTX · S/N H2-99-10-433N322PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC359N327PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC360N335PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC361N567RGDiamond Aircraft Ind DA 40 NG · S/N 40.NC355N580RGDiamond Aircraft Ind DA 40 NG · S/N 40.NC357N582RGDiamond Aircraft Ind DA 40 NG · S/N 40.NC358N685PSDiamond Aircraft Ind DA 40 NG · S/N 40.NC362N714TEPiper PA-28-140 · S/N 28-7525093Sale reportedN876UDCessna 525A · S/N 525A-0147N905RGDiamond Aircraft Ind DA 40 NG · S/N 40.NC353N910QPPowrachute AIRWOLF 912ULS · S/N A369ULSN918DFFritts Dofin A FRITTS 2000 GTXSE · S/N H2 02 13 545
Back to Molino, FL