Aiken, SC
Registered aircraft · 58
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 = 'AIKEN' 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 = 'AIKEN' 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.
N116SRMBB BK 117 A-3 · S/N 7012N117SRMBB BK 117 A-3 · S/N 7084N1192NAmerican General Acft AG5B · S/N 10029N13YSMitsubishi MU-2B-36 · S/N 694N166ESchleicher KA 6 E · S/N 4207N234AJPiper PA-32R-301 · S/N 3246008N2465UCessna 172R · S/N 17281272N249CRBeech 58P · S/N TJ-249N27JHDJI AGRAS T40 · S/N 52LBK6R00100HVN28458Grumman American Avn. AA-5B · S/N AA5B0623N294DWTextron G58 · S/N TH-2478N33562Piper PA-28-140 · S/N 28-7525208N3368FCessna 182J · S/N 18257368N342MCCarra LONG-EZ · S/N 1701N3567NPiper J3C-65 · S/N 22805N360KLLagace Kenneth A LANCAIR 360 · S/N 1N36RCCessna 182N · S/N 18260311N370MAMitsubishi MU-2B-26A · S/N 370SAN3883HMooney M20J · S/N 24-0976N38AFPiper PA-34-220T · S/N 348233001N3MAMitsubishi MU-2B-60 · S/N 1511 S.A.N3QTMooney M20E · S/N 903N4132NCessna 120 · S/N 13595N422GKCirrus Design SR22 · S/N 10996N43335Piper PA-28-151 · S/N 28-7415472N435MDDupont Mark E RV-14A · S/N 140236N4714NCessna 182Q · S/N 18267303N480AFMitsubishi MU-2B-25 · S/N 248N481CGCessna 150L · S/N 15073054N483AFMitsubishi MU-2B-25 · S/N 271N4SCCorley BFB-1A · S/N DCC-3-22-46N5162DCessna 182A · S/N 51262N542LLevy PL-2-130 · S/N EDL1N5733BCessna 182 · S/N 33733N57917Boeing A75N1(PT17) · S/N 75-2086N6199LGreat Lakes 2T-1A-2 · S/N 0726N6311ZBeech F33A · S/N CE-997N6526KStinson 108-2 · S/N 108-2526N6866RCessna T210G · S/N T210-0266N708KSRobinson Helicopter R44 II · S/N 14847N731ATCirrus Design SR22 · S/N 1728N7466TCessna 172A · S/N 47066N748KHJohn Edwin Cornell CALIDUS · S/N C00367N772HLBrandon Scott Lewis ECLIPSE EVO · S/N 01226691025N77GSCessna P210N · S/N P21000613N78PKMitsubishi MU-2B-60 · S/N 1522SAN800CXBeech A36 · S/N E-1435N8132WPiper PA-28-180 · S/N 28-2243N8166ABellanca 7ECA · S/N 88973N82AFMitsubishi MU-2B-40 · S/N 424 S.A.
Back to Aiken, SC