Salisbury, NC
Registered aircraft · 54
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 = 'SALISBURY' 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 = 'SALISBURY' 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.
N1336CCirrus Design SR22 · S/N 0483N1560PPiper PA-18 · S/N 18-3717N18334Beech F33A · S/N CE-728N250WGRaytheon B200 · S/N BB-1780N2575UPiper PA-28-161 · S/N 28-8016042N2743ZSchweizer SGS 1-26C · S/N 246N277SLCessna 172M · S/N 17261652N2933SCessna 150G · S/N 15066833N305RMooney M20K · S/N 25-0231N3112PVans RV-12IS · S/N 121477N3930WPiper PA-32-260 · S/N 32-878N40964Piper J3C-65 · S/N 7722N4232NCessna 120 · S/N 13703N4338QCessna 172L · S/N 17260238Registration pendingN434HCCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 100N4391DDickson David Eugene SONERAI 2-T-B · S/N 021894439N439RPPoole Robert C JR RV-9A · S/N 91603N4738LPiper PA-28-180 · S/N 28-4064N482DRPiper PA-32R-300 · S/N 32R-7780391N485PSSiler Alson G ZODIAC 601XL · S/N 6-5393N494ATP&M QUIK GT450 · S/N 8593N5020PPiper PA-24 · S/N 24-23N51790Grumman American Avn. AA-5A · S/N AA5A-0850N51HNaval Aircraft Factory N3N-3 · S/N 2660N52584Boeing B75N1 · S/N 75-6955N525GABeech B-60 · S/N P-525N53147Cessna 172P · S/N 17274693N5331ZPiper PA-22-108 · S/N 22-9038N53BABeech 200 · S/N BB-426N56406Maule M-5-180C · S/N 8013CN57929Boeing A75 · S/N 75-1376N59625Piper J3C-65 · S/N 13577N62SQEmbraer Executive EMB-500 · S/N 50000456N6792JPiper PA-28-140 · S/N 28-24521N6813UMooney M20C · S/N 2528N68SBBlake Albert S JR ACRO SPORT II · S/N 562N71705Cessna 182M · S/N 18259724N735HLShort Interest KITFOX SPEEDSTER · S/N HBS 051N738MTCessna 172N · S/N 17270090N75EECessna 210L · S/N 21060837N771SYSchweizer SGS 1-26A · S/N 39N777NGCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC059N811XXCubcrafters CC11-160 · S/N CC11-00396N8203GCessna 177RG · S/N 177RG0103N820DSDiamond Aircraft Ind DA 40 · S/N 40.893N8211LCessna 172H · S/N 17256411N8217CInfinity IPP4 · S/N 222N82190Jeffrey Mark D VANS AIRCRAFT RV-14A · S/N 140344N8661UCessna 172F · S/N 17252564N8683RSchweizer SGS 1-26B · S/N 214
Back to Salisbury, NC