Registered aircraft · 22

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'O BRIEN' ORDER BY g.n_number

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 = 'O BRIEN'
  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 = 'O BRIEN'
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.

N13JTCessna 172M · S/N 17261008Built 1972 · Holtzclaw Timothy M N1662LAirborne Windsports REDBACK · S/N 3830Built 2007 · Woodriff R Lee N16630Powrachute PC 2000 · S/N A003FAABuilt 2001 · Woodriff R Lee Dr N1663LKrucker CYGNET · S/N H20018Built 2004 · Woodriff R Lee Dr N18569Cessna 150L · S/N 15073950Built 1972 · Doyle Harley M N238FWBell OH-58A · S/N 70-15223Built 1970 · Southern Helicopter Inc N23TNAmerican Legend AL18 · S/N AL-1206Built 2016 · Hall Robert W N2422DPiper PA-38-112 · S/N 38-79A0306Built 1978 · Mckenzie Sandy S N33102Piper J3L-65 · S/N 5819Built 1940 · Fort Bobby J N39440Stinson 10A · S/N 8240Built 1942 · Hall Robert W N4879HPiper PA-17 · S/N 17-178Built 1948 · Michel Paul J N547CPPendergraff Clyde E VANS RV-7A · S/N 70007Built 2005 · Pendergraff Clyde E N5602GLockwood MU582 DRIFTER · S/N 7-314729479Webb Mark E N5817QMooney M20E · S/N 774Mcinnis Services LLC N705FPFpna A-22 VALOR · S/N 174Built 2007 · Webb Mark E N71698Luscombe 8A · S/N 3125Kaurich Steven J N742DBeech D35 · S/N D-3412Built 1953 · Kaurich Steven N7AACessna 150L · S/N 15072420Bolyard Norma N804LABell Helicopter Textron 206B · S/N 680Built 1971 · Southern Helicopter Inc N85SBStreek Michael GLASAIR II RG · S/N 1082Snk Acft Enterprise LLC N89JKKing James M SKYBOLT · S/N 58Built 1990 · Pendergraff Clyde E N927VSCSP ZENITH 701 · S/N 6353Built 2025 · Certified Security Partnership LLC

Back to O Brien, FL