Homestead, FL
Registered aircraft · 118
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 = 'HOMESTEAD' 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 = 'HOMESTEAD' 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.
N434RHSchempp-Hirth DISCUS CS · S/N 282CSN4374NPiper PA-28-161 · S/N 28-8416128N45079Naval Aircraft Factory N3N-3 · S/N 2690N46036Vans RV-12 · S/N 120271N4699DBoeing Stearman/Huff A75-N1 · S/N RH700N470FSCessna 172M · S/N 17262011N4887GCessna 172N · S/N 17273434N511PTCessna 172M · S/N 17264226N521TTAmerican General Acft AG5B · S/N 10128N5260RCessna 172M · S/N 17263474N5262UCessna 172S · S/N 172S9175N52844Piper J3C-65 · S/N 8954N53509Piper PA-28R-201 · S/N 2844071N551APCessna 172P · S/N 17276056N553APCessna 172P · S/N 17274554N555CVCessna 172M · S/N 17267112N555RLAviat PITTS S-2B · S/N 5307N5733TCessna 172E · S/N 17251633N59AACompagnie Daher TBM 700 · S/N 1234N6087UAviat A-1 · S/N 1285N610FLPiper PA-28-140 · S/N 28-7125488N61588Cessna 172M · S/N 17264661N61697Cessna 172M · S/N 17264738N61739Cessna 172M · S/N 17264765N617EDPiper PA-24-260 · S/N 24-4765N62516Pilatus B4-PC11 · S/N 063N6271BCessna U206G · S/N U20603839N6277American Legend AL11 · S/N AL-1038N62899Piper PA-31-350 · S/N 31-7652122N63169Cessna 150M · S/N 15077153N649GCCessna 172N · S/N 17273413N669XChampion 7ECA · S/N 68N671JJabiru USA Sport J250-SP · S/N 576N6824WPiper PA-28-140 · S/N 28-20962N709PTCessna 172M · S/N 17261533N7136SCessna 150H · S/N 15067836N713LBTextron 525C · S/N 525C0492N7242GCessna 172K · S/N 17258942N735VPCessna 182Q · S/N 18265721N74FCRichard A Carson ZENITH 750 STOL · S/N 7510495N760FSPiper PA-34-200 · S/N 34-7250213N78GHPiper PA-31-350 · S/N 31-7852121N793PTCessna 172M · S/N 17263842N7ERRockwell-Edward VARI-EZE · S/N 374N8023Let L-23 SUPER BLANIK · S/N 938023N8091NQuicksilver SPORT II · S/N 000612N810FSCessna 172N · S/N 17272297N81123Mcclish FUNK B85C · S/N 253N844WCExtra Flugzeugproduktions UND EXTRA NG · S/N NG068N86WECessna 206H · S/N 20608243
Back to Homestead, FL