Longwood, FL
Registered aircraft · 70
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 = 'LONGWOOD' 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 = 'LONGWOOD' 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.
N108DUGulfstream Aerospace G-IV · S/N 1149N114AMCessna 310R · S/N 310R0887N125KBRobert B Beaty RV-10 · S/N 41352N126BWWithrow Brian E BUCCANEER XA · S/N A276-503N129DCDavid Mazer SEAREY LSX · S/N 1LK574CN143CCCub Crafters PA18-150 · S/N 9956CCN1458Brown Garry M RV-4 TD · S/N 1621N15564Piper PA-28-235 · S/N 28-7310056N1962JCessna 750 · S/N 750-0240N199SRReiche Robert Brian SEAREY · S/N 1MK099N20DZSocata TB-20 TRINIDAD · S/N 615N217EXExtra Flugzeugbau EA 300/L · S/N 1217N2368PPiper PA-18A 150 · S/N 18-4257N23CKMeadows Denny CLIP WING CUB · S/N DM3N2504MPiper PA-12 · S/N 12-1002N2604FAeronca 7AC · S/N 7AC-6186N278ASPilatus B4-PC11AF · S/N 251N280HLIai GULFSTREAM G280 · S/N 2102N293WYAviat A-1C-180 · S/N 3293N298RBGulfstream Aerospace G-IV · S/N 1341N30685Cessna 177B · S/N 17701404N307CGCharles W Gregg SR RV-7A · S/N 73760N33HCCirrus Design SR22 · S/N 0815N33MRRossum Michael M RV7A · S/N 72735N3410ACessna 560XLS · S/N 560-5739N3498TCessna 177 · S/N 17700798N3512HMooney M20J · S/N 24-1032N3571LPiper PA-28-236 · S/N 28-8011071N36DZGulfstream American G-1159A · S/N 450N37777Cessna 337C · S/N 337-0898N403SBGulfstream Aerospace G-IV · S/N 1417N40YKNanchang China CJ-6A · S/N 2532077N413JRGaver K D JR OUTBACK · S/N 228N438DDJames Folsom VANS ACFT INC RV-7 · S/N 74113N4512Fleet FLEET 16B · S/N 285N45156Cessna 150M · S/N 15076760N4522YPiper PA-25-235 · S/N 25-4030N472MMGulfstream Aerospace G-IV · S/N 1072N4BBPilatus B4-PC11 · S/N 020N504BBBellanca 7GCBC · S/N 504-73N523American Eagle 129 · S/N 393N52747Cessna 172P · S/N 17274598N53099Pemberton Walter Bruce XA 650 · S/N B2A026N533BTConsolidated Vultee/Vanech BT-13A · S/N 10060N544MHRobinson Helicopter R44 · S/N 0739N605RAGulfstream Aerospace G-IV · S/N 1028N614MDavid Mazer VANS RV-8 · S/N 83080N619MLGulfstream Aerospace G-IV · S/N 1062N61WFLearjet 60 · S/N 313N6241ACessna 182 · S/N 33041
Back to Longwood, FL