Port Orange, FL
Registered aircraft · 444
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 = 'PORT ORANGE' 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 = 'PORT ORANGE' 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.
N1010MHautamaki Charles A GLASAIR SH-2 · S/N 119N101FTNorth American T-6G · S/N 49-3380N103LFChang Tien-Chien RV-9A · S/N 91048N108JTBeech A36 · S/N E-1355N109TGAgusta A109E · S/N 11680N110YAYakovlev YAK-50 · S/N 863110N114PAHoward Dean RV-14 · S/N 140552N11EUChristian Martin EUROPA XS · S/N A291N120MYMysky MS-1 · S/N 0001N1218GBarth George E RV6A · S/N 25085N121TKVans RV-12 · S/N 120845N12713Cessna 172M · S/N 17262198N129RBAmerican Legend AL18 · S/N AL-1231N12BWRichard A Weiss VANS RV-7A · S/N 73415N12PDVans RV-12 · S/N 120674N142GXMooney M20R · S/N 29-0342N1432PCessna 172P · S/N 17274334N143PDBeech A45 · S/N 53-4134N1492TPiper PA-28R-200 · S/N 28R-7235305N150PSSmith Philip D RV-8 · S/N 80691N151LCColumbia Aircraft Mfg LC42-550FG · S/N 42501N151PCessna T337G · S/N P3370058N156TCTien-Chien Chang RV-10 · S/N 42000N157LWRechsteiner W/Mettler L AIR CAM · S/N ACO42N159WPWilliam Philip Hale VANS RV-8 · S/N 82463N160HPDory Joe VANS RV-4 · S/N 1852N160THHughes Helicopters HUGHES 369D · S/N 770160DN161GLGreat Lakes 2T-1A-2 · S/N 0814N1625NMcclish FUNK B85C · S/N 405N164CBBrooks Chris A RV6 · S/N 22935N165BBJacobsen Robert A JR EUROPA XS MONOWHEEL · S/N A131N1662JPiper PA-28-140 · S/N 28-24059N166JRRonk Jerry F1 · S/N 042N16YSJohn M NYS NYS JOHN M RV10 · S/N 41251N17230Cessna 150L · S/N 15073679N172NCCessna 172L · S/N 17260468N174TMRR Heli MOSQUITO XET · S/N MXE1121L10BN17748Beech A36 · S/N E-1017N178QBeech S35 · S/N D-7560N17BEEllison Benjamin L LONG-EZ · S/N 1471N180BRCessna 180 · S/N 31386N184TAAgin Thomas L RV-8 · S/N 82714N18760Beech V35B · S/N D-10070N18FKTim Plunkett SC FOKKER D7 · S/N 0001N18RWBeech H-18 · S/N BA-653N193JFFriend Joseph J RV-9 · S/N 9958N1943HBoeing B75N1 · S/N 75-7903N195DCCessna 195A · S/N 7734N195GTCessna 195B · S/N 16055N195LNCessna 195 · S/N 7824
Back to Port Orange, FL