Myrtle Beach, SC
Registered aircraft · 98
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 = 'SC' AND g.registrant_city = 'MYRTLE 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 = 'SC' AND g.registrant_city = 'MYRTLE 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.
N56382Piper PA-28-180 · S/N 287305580N5782JCessna 172N · S/N 17273835N5944DPiper PA-22-150 · S/N 22-4607N59PGCessna 172L · S/N 17260347N6077JCessna 182P · S/N 18263627N623SRCirrus Design SR22 · S/N 2461N639MRPiper PA-28-151 · S/N 28-7515293N646AFCirrus Design SR22 · S/N 11355N6479QMooney M20F · S/N 680021Registration pendingN6492CBeech C90 · S/N LJ-1050N6530HCessna 172M · S/N 17265477N654MDiamond Aircraft Ind DA 40 · S/N 40.412N65853Cessna 182T · S/N 18281490N667DGCirrus Design SR20 · S/N 2463N6719FPiper PA-34-200T · S/N 34-7770034N679SPMcdaniel Shayne W RV-9A · S/N SWM-5-9A-90590N68LXExtra Flugzeugproduktions-Und EA 300/LC · S/N LC068N7197VRobinson Helicopter R44 · S/N 0692N7206QCessna 172L · S/N 17260506N7229JPiper PA-28-140 · S/N 28-24565N73182Cessna 182 · S/N 18261434N732YSMooney M20J · S/N 24-3269N736PKCessna R172K · S/N R1722679N742DMMclendon Donald E VANS RV-7 · S/N 70711N74784Robinson Helicopter R44 II · S/N 10925N7507XRobinson Helicopter R44 · S/N 1218N759NLCessna 182Q · S/N 18266126N76613Cessna 140 · S/N 11053N777AWBeech 200 · S/N BB-536N7996UCessna 172F · S/N 17251996N803PCirrus Design SR20 · S/N 2526N814BAlexander S Rolinski BOT JOURNEY · S/N SC20-014N81DJArion LIGHTNING LS-1 · S/N 42First renewal noticeN8322LPiper PA-32R-301T · S/N 32R-8129032N8333ZRobinson Helicopter R44 · S/N 0249N843FRRobinson Helicopter R44 · S/N 0562N862MMRobinson Helicopter R44 II · S/N 11350N876CPCirrus Design SR22 · S/N 3271N897ARaytheon HAWKER 800XP · S/N 258326N898TCCessna 310K · S/N 310K0084N911TMRobinson Helicopter R44 II · S/N 10194N91ETPiper PA-32RT-300 · S/N 32R-7985083N9510QSmith AEROSTAR 601P · S/N 61P-0344-103N959CDCirrus Design SR22 · S/N 1808N95WDBeech F33A · S/N CE-322N9867LGrumman American Avn. AA-1B · S/N AA1B-0467N9868QCessna 172M · S/N 17265812N9912DMaule MXT-7-180 · S/N 16001C
Back to Myrtle Beach, SC