Opa Locka, FL
Registered aircraft · 46
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 = 'OPA LOCKA' 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 = 'OPA LOCKA' 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.
N1333ECessna 172S · S/N 172S10404N138MFCirrus Design SR20 · S/N 1938N163QBeech 95-B55 · S/N TC-671N172UCCessna 172N · S/N 17271911N194MLPiper PA-23-250 · S/N 27-7954081N19679Cessna 172L · S/N 17260662N20332Cessna 172M · S/N 17261197N20472Cessna 172M · S/N 17261315N226MPGulfstream Aerospace G-IV · S/N 1300N250EXIsrael Aircraft Industries GULFSTREAM 100 · S/N 139N2615QCessna 402C · S/N 402C-0321N305FCLearjet 45 · S/N 2063N305NCCessna 208B · S/N 208B5052N305TTBeech C90 · S/N LJ992N305ZARaytheon C90A · S/N LJ-1439N333EACirrus Design SR20 · S/N 11373N395LCPiaggio P180 · S/N 1052N423JLBombardier BD-700-1A10 · S/N 60138N426LJCessna 402C · S/N 402C0434N4500XGulfstream Aerospace GVII-G600 · S/N 73036N4887EAeronca 7EC · S/N 7EC696Revoked, canceledN510FACessna 172N · S/N 17268470N5223RCessna 172M · S/N 17263437N52FCExtra Flugzeugbau EA 300/L · S/N 170N561ZABeech B200 · S/N BB1180N57119Sikorsky UH-60L · S/N 93-26491N575BGBombardier BD-700-1A10 · S/N 9803N6026JCessna 162 · S/N 16200145N611EACessna 172N · S/N 17272471N636JSBombardier BD-700-1A11 · S/N 9325N6854HCessna 172M · S/N 17265610N701MEBeech 95-B55 (T42A) · S/N TC-1159N728CRCessna 550 · S/N 550-0159N731EAColumbia Aircraft Mfg LC41-550FG · S/N 41518N786ZABeech C90A · S/N LJ1388N800KWCessna 402B · S/N 402B1063N800SDRaytheon 400A · S/N RK-270N800UWRaytheon HAWKER 800XP · S/N 258395N82RSRaytheon HAWKER 800XP · S/N 258336N8321BCessna 172 · S/N 36121N850UXRaytheon HAWKER 800XP · S/N 258632N850XMRaytheon HAWKER 800XP · S/N 258426N90KABeech B90 · S/N LJ-369N954ZARaytheon B200 · S/N BB-1712N986HHIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 041N987TSDiamond Aircraft Ind DA 42 · S/N 42.AC088
Back to Opa Locka, FL