Ocean Springs, MS
Registered aircraft · 24
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 = 'MS' AND g.registrant_city = 'OCEAN SPRINGS' 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 = 'MS' AND g.registrant_city = 'OCEAN SPRINGS' 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.
N1196AAmerican General Acft AG5B · S/N 10103N119FTextron T206H · S/N T20609826N119MHeadrick James C RV6A · S/N 25250N1265SCessna 182P · S/N 18264833N136RKBeechcraft G36 · S/N E-4069N208TTGillingham Giff TORNADO II · S/N D96582SOHK0208N211LVGoodloe W/Goodloe M VANS RV-9A · S/N 90714N228JHCessna 421C · S/N 421C-1006N2852VPiper PA-28-181 · S/N 28-7990497N3524WPiper PA-32-260 · S/N 32-409N384RVGillespie Byron W RV-14A · S/N 140466N4307PPiper PA-23-160 · S/N 23-1808N432KCPiper PA-32R-301 · S/N 3246225N501NYCessna 501 · S/N 501-0038N5055ZPiper PA-22-108 · S/N 22-8679N5433PPiper PA-24-180 · S/N 24-487N5476UBeech 95-B55 (T42A) · S/N TC-1037N6292AHostetter Ira S RANS S-12 · S/N 0294476N736SDCessna R172K · S/N R1722745N73JKCessna 150G · S/N 15064948Registration ineffective or invalidN8486CPiper PA-28-140 · S/N 28-7625120N9224YPiper PA 31P 350 · S/N 31P-8414012N9229DPiper PA-22-160 · S/N 22-6289N9779NReed Stuart ARION LIGHTNING · S/N 00094
Back to Ocean Springs, MS