Labelle, FL
Registered aircraft · 57
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'LABELLE' 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 = 'LABELLE' 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.
N11MZCirrus Design SR22 · S/N 0108N14207Piper PA-23-250 · S/N 27-4767N14501Schweizer SGS 2-33 · S/N 59N1691NBellanca 8KCAB · S/N 18-72N191WBeech 95-B55 (T42A) · S/N TC-577N198APiper J3C-65 · S/N 19431N21KGBeech F90 · S/N LA-149N2212EChampion 7BCM · S/N 7AC-5786N2375EChampion AERONCA 7AC · S/N 7AC-5952N2626Beech F17D · S/N 283N2690HSchweizer SGS 2-33A · S/N 510N2951GChampion 7GCBC · S/N 62N299CNGrumman G-44 · S/N 1299N306QCBeech A60 · S/N P-190N3265SCessna 182G · S/N 18255765N326DPPiper PA-32-260 · S/N 32-854N374MLMichael L Lowe EXCALIBUR · S/N 01152021N38872Piper J5A · S/N 5-1094N4097KPiper PA-31-350 · S/N 31-8152191N42277Piper J3C-65 · S/N 14527N42FYJones Michael PURPLE PEOPLE SEATER · S/N 01N4423LCessna 172G · S/N 17254512N46789Piper J3C-65 · S/N 10589N4691FPiper PA-32R-300 · S/N 32R-7680474N496HBoeing B75N1 · S/N 75-6847N498UMDJI AGRAS T50 · S/N 1581F6BUB248D001QHX0N502NPAlexander Rolinski AVENTURA II · S/N AA2A0166N511JFedelem Joseph J PIETENPOL AIR CAMPER · S/N ELF-1N53430Ryan Aeronautical ST3KR · S/N 1822N54766Boeing A75N1(PT17) · S/N 75-2739N582UMDJI AGRAS T50 · S/N 1581F6BUB24B6001R8YRN59280Boeing A75N1(PT17) · S/N 75-1455N616RPBeech 300 · S/N FA-181N6231FCessna 172N · S/N 17273170N64JCGlaser-Dirks DG 600 · S/N 6-14N65467Boeing B75N1 · S/N 75-6928N6584CAerostar International RX-7 · S/N RX7-3109N681SPAero Commander 681 · S/N 6027N704ZRCessna 150M · S/N 15079007N7569PPiper PA-24-180 · S/N 24-2780N756EFCessna R182 · S/N R18201048N761WWood PL-2 · S/N 60N8200KMckean Graeme RV-6 · S/N GTM4N82950Aeronca 7AC · S/N 7AC-1601N83212Piper PA-32R-301 · S/N 32R-8113034N834KNSlingsby SLINGSBY T67M260 · S/N 2243N834SSSlingsby SLINGSBY T67M260 · S/N 2273N836SSSlingsby SLINGSBY T67M260 · S/N 2271N837SSSlingsby SLINGSBY T67M260 · S/N 2258N838SSSlingsby SLINGSBY T67M260 · S/N 2277
Back to Labelle, FL