Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'PONTE VEDRA' ORDER BY g.n_number

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 = 'PONTE VEDRA'
  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 = 'PONTE VEDRA'
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.

N135EKKunse Elmer F8L FALCO · S/N 902Ec Aviation Group Corp N1443DDubiak Alvin FALCO F.8L · S/N 1097Built 2000 · Ec Aviation Group Corp N15GKBeech 95-B55 (T42A) · S/N TC-1681Built 1974 · 427 Siera Lima LLC N179GCConnell Greg F-1 ROCKET · S/N 062Built 2005 · Wolfpacc Inc N188KCPiper PA 46-350P · S/N 4636588Built 2013 · Malibu Management LLC N2462VCessna 140 · S/N 14715Neal Mark M N3146SNYS John M RV-10A · S/N 40047Built 2005 · Bell Stephen Francis Trustee N316PBTextron G36 · S/N E-4088Built 2016 · Davison David D N3NYNaval Aircraft Factory N3N-3 · S/N 1920Registration pending, pending cancellationBuilt 1939 N445VRBeech 400A · S/N RK-45Built 1992 · Ronco-Wales LLC N502PWAirborne EDGE · S/N 582-913Built 2004 · Simpson Stephen L N67MACessna 680 · S/N 680-0148Built 2007 · Chartair Holdings LLC N805SHHansen Karl/Steven FALCO F8L · S/N 805Ec Aviation Group Corp N814JTCarlos Torrealba RV-14A · S/N 140280Torrealba Carlos N902PTTroy E Cole SLING TSI · S/N 410SKBuilt 2024 · Tcg Aviation LLC N90BKCessna P337 · S/N P3370306Anderson Stephen Michael N936GHawker Beechcraft G36 · S/N E-3816Built 2007 · Campbell Merle W

Back to Ponte Vedra, FL