Miramar, FL
Registered aircraft · 49
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 = 'MIRAMAR' 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 = 'MIRAMAR' 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.
N106SABeech 300 · S/N FA206N1247UCessna 172M · S/N 17266942N126MCTextron B300 · S/N FL-183N128MGPiper PA-31-325 · S/N 31-7712074N1576MCessna T210M · S/N 21061948N169HCCessna 172M · S/N 17262693N18145Cessna 150L · S/N 15073818N208SEPiper PA-23-250 · S/N 27-4542N2171WBeech B19 · S/N MB-688N21TMMiller DAVIS DA-2A · S/N 112N2296QPiper PA-32R-300 · S/N 32R-7780244N292BWCessna 208 · S/N 20800403N318TWCessna 421 · S/N 421-0170N352VRVashon RANGER R7 · S/N 10205N3581FCessna A150L · S/N A1500413N378AWRaytheon 1900D · S/N UE-378N39JCRaytheon 390 · S/N RB-61N404ECCessna 404 · S/N 404-0646N40919Piper PA-31-350 · S/N 31-8152162N4443DBeech G35 · S/N D-4580N444FLCessna 172N · S/N 17268861N45050Piper PA-23-250 · S/N 27-4271N450XXGulfstream Aerospace GIV-X (G450) · S/N 4062N4541TPiper PA-28R-200 · S/N 28R-7235083N461ARGulfstream American G-1159A · S/N 384N4655WRockwell International 112TCA · S/N 13185N47929Piper PA-28-161 · S/N 28-7816161N51007Christian Von Kessel SW-51 MUSTANG · S/N 007N532SAAero Commander 500 S · S/N 1868-44N5566UPiper PA-28-140 · S/N 28-26293N5619LAmerican AA-1 · S/N AA1-0021N56591Piper PA-28-140 · S/N 28-7325664N57350Piper PA-28-140 · S/N 28-7425096N690SERockwell International 690B · S/N 11463N7036DPiper PA-22-150 · S/N 22-4934N72213Raytheon C90A · S/N LJ-1450N738NUCessna 172N · S/N 17270115N7576ANorth Wing Design AST 503B · S/N 4918N7770UCessna 172E · S/N 17251770N781GHPiper PA-32RT-300 · S/N 32R-7885141N790HMSocata TB 9 TAMPICO · S/N 1334N87MUCessna U206G · S/N U20605271N901DPWaco Classic YMF · S/N F5C087N90JZBeech C90A · S/N LJ-1239N954JCCessna T303 · S/N T30300209N95JCHawker Beechcraft 390 · S/N RB-233N98244Piper PA-28-140 · S/N 28-26002N998LLCirrus Design SR20 · S/N 2425N999PDWaco Classic YMF-F5C · S/N F5C108
Back to Miramar, FL