Spartanburg, SC
Registered aircraft · 67
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 = 'SPARTANBURG' 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 = 'SPARTANBURG' 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.
N100JBCirrus Design SR22 · S/N 10290N117SZBurkhart Grob G-103A TWIN II ACRO · S/N 34074-K-304N142SCHughes 369A · S/N 1180910N153PBPilatus PC-12 · S/N 153N171ATAero Commander 680V · S/N 1616-49N181EFGates Learjet 35A · S/N 190N182EBCessna R182 · S/N R18201520N185ACAmerican Champion 8KCAB · S/N 723-93N20068Cessna 172M · S/N 17260980N2019YCessna 172C · S/N 17249519N216JACessna 172RG · S/N 172RG0467N247JDBombardier BD-100-1A10 · S/N 20598N25265Cessna 152 · S/N 15280561N269JRGates Learjet 35A · S/N 224N292AWPiper PA-32-300 · S/N 32-7840061N293AWDJI SPARK · S/N 0ASDE8S0B10029N305SABeech 300 · S/N FA-111N3064PBurkhart Grob Flugzeugbau ASTIR CS · S/N 1052N3193CLanny SR71 · S/N 004N320GBBeech G18S · S/N BA-509N320GNNeal Gary C RTRY A F 2000 GTX SE · S/N 77666952N345KSKouros Sassani SPORTSMAN GS-2 · S/N 7461N3503JCessna 150E · S/N 15061203N351CTBombardier BD-100-1A10 · S/N 20770N3586XPiper PA-31-310 · S/N 31-8012070N37NCGlace Charles L GLASAIR II FT · S/N 1079N381S.O.C.A.T.A. RALLYE 150 ST · S/N 3072N3869TPiper PA-28R-180 · S/N 28R-30193N3901CCessna 150H · S/N 15069096N3988TPiper PA-28R-180 · S/N 28R-30340N3LSBeech E-90 · S/N LW-245N453PSCzech Sport PIPER SPORT · S/N P1001053Registration pendingN4856TCessna R182 · S/N R18201777N500TJCessna 421B · S/N 421B0585N503AMCessna 172P · S/N 17275767N50854Cessna 150J · S/N 15069600N5201DMooney M20J · S/N 24-0578N52344Cessna 172P · S/N 17274497N525WBCessna 525 · S/N 525-0079N527JGGulfstream Aerospace GV-SP (G500) · S/N 5067N537GSGulfstream Aerospace GVII-G500 · S/N 72037N6040UTukan 2 PLACE · S/N 001N6115CCessna 421C · S/N 421C0890N6469WPiper PA-28-140 · S/N 28-20542N6500BLancair LC-40-550FG · S/N 40043N66GVCessna 172M · S/N 17263861N67099Bell 206B · S/N 5108N6725TBeech 58 · S/N TH-1423N67WJCessna 150L · S/N 15074915N7258SCessna 150H · S/N 15067958
Back to Spartanburg, SC