Englewood, FL
Registered aircraft · 45
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 = 'ENGLEWOOD' 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 = 'ENGLEWOOD' 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.
N101FYIrvin F Holdgate IRVIN F HOLDGATE · S/N 001N126BEMooney M20J · S/N 24-3248N132STPiper PA32-301FT · S/N 3232035N13483Cessna 172M · S/N 17262784N162AWPiper PA-18-150 · S/N 18-8109082N181CBeech B95 · S/N TD-440N18684Fairchild 24W-9 · S/N 201N1996MCessna 182P · S/N 18264525N2165WBeech B24R · S/N MC252N2378Robinson Helicopter R22 BETA · S/N 2066N23HCCirrus Design SR22 · S/N 5032N2551TNavion NAVION H · S/N NAV-4-2551N284RACessna 172P · S/N 17276151N3424ABeech A45 (T-34A) · S/N 34-24N36346Taylorcraft DF-65 · S/N 4083N392JNNewman John F RV-7A · S/N 72474N42049Cessna 182L · S/N 18258830N421LQCessna 421C · S/N 421C0883N47747Fairchild M-62A · S/N T43-5488N5180ACessna 172 · S/N 28180N5249MTaylorcraft BC12-D · S/N 10549N55062Boeing A75 · S/N 75-221N557DBBeech A45 · S/N G-789N59QCorben Baby Ace C · S/N 001N601FHHoldgate Irvin F ZODIAC CH 601XLB · S/N 6-4426N601RFCessna 180J · S/N 18052560N6747PPiper PA-24-180 · S/N 24-1875N691KTravel Air E-4000 · S/N 1277N6976QBeech A23-24 · S/N MA-339N6MDCessna 210-5(205) · S/N 2050315N73391Cessna 172M · S/N 17267423N748BJJones Peter M BOEING/JONES 75 · S/N AR-42N7496BChampion AERONCA 7FC · S/N 7FC-4N750RFFowlkes Richard L AIR CAM · S/N AC088N797ACAmerican Champion 8KCAB · S/N 797-97N800XLSea & Sky CYGNET · S/N H2004N807SRCirrus Design SR22 · S/N 2067N8089GCessna 177RG · S/N 177RG0089N80995Globe GC-1B · S/N 1188N81313Fairchild 24R-46A · S/N R46-213N82319Piper PA-28-236 · S/N 28-8011122N853SBRobinson Helicopter R44 II · S/N 14860N881RJPiper PA32-301FT · S/N 3232049N891SSSnow Stephen F EXCALIBUR · S/N 905694N954BSDehavilland DHC-2 · S/N 83
Back to Englewood, FL