Miami Beach, FL
Registered aircraft · 89
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 = 'MIAMI BEACH' 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 = 'MIAMI BEACH' 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.
N100PFCessna 525 · S/N 525-0390N1054KMooney M20R · S/N 29-0266N107TVBoeing 757-23A · S/N 24527N120CUEurocopter EC120B · S/N 1399First renewal noticeN12572Cessna 172M · S/N 17262083N147JLLindberg James EDGE-X · S/N 001N14VRWooten Bobby Don LANCAIR 360 · S/N 724-320-57N1625LSocata TB 10 · S/N 13N167ADGulfstream Aerospace GIV-X (G450) · S/N 4197N17JGCirrus Design SR22 · S/N 4771Non-citizen corporation, flight hours not reportedN1953YMooney M20E · S/N 260N1970Cirrus Design SR22 · S/N 0063N19801Cessna 172M · S/N 17260764N21181Cessna 182P · S/N 18261470N2250XPiper PA-28RT-201 · S/N 28R-7918097N234ZTRobinson Helicopter R44 · S/N 30027N24MHLearjet 60 · S/N 185N2895LPiper PA-28RT-201 · S/N 28R-7918205N2FDCanadair CL-600-2B16 · S/N 5345N3048LCessna 310J · S/N 310J0048N305RPCirrus Design SR22T · S/N 10349N3062CYakovlev YAK 52 · S/N 855912N3131AGulfstream Aerospace GV-SP (G550) · S/N 5021N313JPHughes 369HS · S/N 1120428SN324PKPiper PA-46-600TP · S/N 4698074N325HQGulfstream Aerospace GV-SP (G550) · S/N 5391N326VRVashon RANGER R7 · S/N 10180N33JJAmerican AA-5 · S/N AA5-0061N344KDBoeing 747-446 · S/N 26344N356KDBoeing 747-446 · S/N 26356N370CTFlight Design CTLS · S/N F-16-01-52N3730GBeech C24R · S/N MC-736N381TATextron 208B · S/N 208B5434N384JWLearjet 60 · S/N 130N39TFBeech F33A · S/N CE-636N411ZFShort Brothers S312 TUCANO T MK1 · S/N T101N422CGIcon A5 · S/N 00120N422TGCessna 510 · S/N 510-0429N441HPCessna T206H · S/N T20608240N443HPCessna T206H · S/N T20608241N45EYCirrus Design SF50 · S/N 0535N47CECirrus Design SF50 · S/N 0672N48RSBeech V35 · S/N D-8250N500CWLearjet 60 · S/N 133N518GPGulfstream Aerospace GV-SP (G550) · S/N 5051N53622Cessna 172P · S/N 17274788N53GBBell Textron Canada 505 · S/N 65660N541ACPiper PA-34-200T · S/N 347570129N545JNMcdonnell Douglas MD-11F · S/N 48545N550GFGulfstream Aerospace GV-SP (G550) · S/N 5284
Back to Miami Beach, FL