Fort Lauderdale, FL
Registered aircraft · 606
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 = 'FORT LAUDERDALE' 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 = 'FORT LAUDERDALE' 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.
N101BLFernando Heluey Moreira VANS RV-10 · S/N 42753N101NDLearjet 60 · S/N 037N1026VCessna 208B · S/N 208B0319N1029YCessna 208B · S/N 208B0325N102AZTextron B200GT · S/N BY-295N104HPWatts/Perl CHRISTEN EAGLE II · S/N WATTS/PERL 0001N1051WMaule MXT-7-180A · S/N 21035CN106DLMesserschmitt-Bolkow-Blohm GMB BO 105M · S/N 5027N106KHRaytheon 400A · S/N RK-323N1073FCessna 172N · S/N 17272946N109BCEurocopter Deutschland EC135T1 · S/N 0139N1115MCessna 208B · S/N 208B0356N112CZCessna 441 · S/N 441-0233N11606Mooney M20J · S/N 24-1276N116SFBombardier BD-700-1A10 · S/N 9709N117BGCessna 650 · S/N 650-0007N117KDCirrus Design SR20 · S/N 1072N118ARCirrus Design SR22 · S/N 3772N1206UCessna 172S · S/N 172S10417N120KAHonda HA-420 · S/N 42000120N121BDCessna 414A · S/N 414A0297N1232YCessna 208B · S/N 208B0566N123CWCessna 310Q · S/N 310Q0975N124HBCessna 650 · S/N 650-7067N1250CPiper PA-31P · S/N 31P-7530011N1262MCessna 182P · S/N 18264265First renewal noticeN1277FCessna 172N · S/N 17272982N127EJRaytheon 400A · S/N RK-127N1292PPiper PA-23 · S/N 23-327N1296YCessna 208B · S/N 208B1079N1297TPiper PA-32-300 · S/N 32-7240112N131JLBritten-Norman BN-2A · S/N 225N1326SDassault FALCON 2000EX · S/N 737N13SKCessna 172N · S/N 17271183N1420VRockwell International 690B · S/N 11524N143CBIsrael Aircraft Industries GALAXY · S/N 043N144HPPiper PA46R-350T · S/N 4692044N1459AGulfstream Aerospace G-IV · S/N 1459N145CGTextron 525B · S/N 525B-0480N146BGGulfstream Aerospace G-IV · S/N 1146N146WMCessna 208B · S/N 208B-0813N1474TPiper PA-32-300 · S/N 32-7240125N154AKLearjet 60 · S/N 114N154GGulfstream Aerospace G-IV · S/N 1044N156AWDassault-Breguet FALCON 50 · S/N 184N15USCessna T210L · S/N 21060676N160DSSalcedo Daniel R PITTS S-1-11 · S/N 0014N1627QCessna 150L · S/N 15072927N162DLHiller UH-12A · S/N 224N162GACessna 208B · S/N 208B0667
Back to Fort Lauderdale, FL