Southport, NC
Registered aircraft · 37
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 = 'NC' AND g.registrant_city = 'SOUTHPORT' 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 = 'NC' AND g.registrant_city = 'SOUTHPORT' 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.
N1039SMooney M20R · S/N 29-0318N126SPCessna 172S · S/N 172S9796N1860WBeech V35B · S/N D-9500N23007Luscombe 8A · S/N 930N231KLMooney M20K · S/N 25-0284N244DDBeechcraft G36 · S/N E-4044N247BLBurleson Jack D VANS RV-4 · S/N 247N3278SCessna 182G · S/N 18255778N3343LBeech C24R · S/N MC-466N39541Piper PA-32RT-300T · S/N 32R-7887104N43290Taylorcraft BC12-D · S/N 6949N43728Piper PA-32R-301T · S/N 32R-8429025N47GABeech 58 · S/N TH-547N519SMJohn H Mcglynn III RANS S-19 · S/N 030900063N570BLJabiru Aircraft PTY J230-D · S/N 983N5754QMooney M20C · S/N 3079N5914BCessna 182A · S/N 33914N5996BCessna 182A · S/N 33996N655EBVans RV-12IS · S/N 12076N68CDBeech B90 · S/N LJ-366N695DSDiamond Aircraft Ind DA 40 · S/N 40.865N71XTWorld SPIRIT · S/N 01-12-15-052N7247ECessna 182B · S/N 52247N724HRHeller Martin VANS RV-7 · S/N 70018N731MCCessna 182Q · S/N 18265598N736FNCessna R172K · S/N R1722493N7625SBellanca 7GCAA · S/N 330-76N7925LBeech A23-24 · S/N MA-112N812MCCessna 182T · S/N 18281208N818PPGuinn Martin R RV-14A · S/N 140676N8212GCessna 177RG · S/N 177RG0112N8320MCessna 182P · S/N 18264592N841RVReynolds Richard V VANS ACFT RV-6A · S/N 24956N863AGDJI MAVIC 2 ZOOM · S/N 0M6DF8L0019PT8N9220SBeech B24R · S/N MC-380N959RMCessna 172K · S/N 17259113N986JWWoehl Jack L RV6A · S/N 22925
Back to Southport, NC