Registered aircraft · 20

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'CHAPIN' ORDER BY g.n_number

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 = 'CHAPIN'
  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 = 'CHAPIN'
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.

N11841Cessna 150L · S/N 15075667Built 1974 · Amor Aviation LLC N143RFVashon RANGER R7 · S/N 10199Built 2022 · Colley Ronald N158TZCommander 114TC · S/N 20037Built 2000 · Boney George C Jr Trustee N1800CBombardier CL-600-2B19 · S/N 7351Built 1999 · Gazillion Air LLC N219SRProgressive Aerodyne SEAREY LSA · S/N 1041Built 2015 · Crystal Lake Holdings LLC N225ECBuckeye Industries BUCKEYE DREAM MACHIN · S/N 3568Built 1996 · Prim Peter N24ENCirrus Design SR22 · S/N 4769Built 2019 · Ekman Co LLC N26360Grumman American Avn. AA-5A · S/N AA5A0543Built 1978 · Stickney John M N31VJCirrus Design SF50 · S/N 0367Built 2022 · Gazillion Air LLC N41TGBeech 95-B55 (T42A) · S/N TC-1581Built 1973 · Busch John N51357Thurnheer Daniel FLIGHTSTAR II · S/N 11SC5011Registration pendingBuilt 2000 N563PNorman Barry PULSAR III · S/N P9903-0563Built 2005 · Norman Barry G N5858ZHylio AG-130 · S/N 050218Bemis Andrew G N7711QCessna 310N · S/N 310N-0073Built 1968 · Hot Start Aviation LLC N793AACessna 501 · S/N 501-0106Built 1979 · Mch Aviation LLC N80VJCirrus Design SR20 · S/N 2318Built 2016 · Ekman Evan F N8202DBeech H35 · S/N D-5325Built 1957 · Hot Start Aviation LLC N8416ZCessna 210-5(205) · S/N 205-0416Swamp Fox Aviation LLC N9230SBeech C23 · S/N M-1791Built 1976 · Slominski Marcus A N9268QBeech A36 · S/N E-279Built 1971 · Weyhmuller Luke

Back to Chapin, SC