Beaufort, SC
Registered aircraft · 52
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 = 'BEAUFORT' 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 = 'BEAUFORT' 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.
N125MTPiper PA-28R-201 · S/N 2844093N1419GBeech P35 · S/N D-6900N143MRVans RV-12 · S/N 120303N149SRProgressive Aerodyne SEAREY LSA · S/N 1024N1517ZBeech 35-B33 · S/N CD-412N16398Piper PA-28-180 · S/N 28-7305244N1749QCessna 150L · S/N 15073049N1947BLuscombe 8F · S/N 6374N2064FTextron T206H · S/N T20609687N229MGJohn A Brewer SPORTCOPTER VORTEX M · S/N 175N27227American Legend AL3 · S/N AL-1171N302DBCessna 177 · S/N 17701132N309PTCirrus Design SR22 · S/N 2434N3161PPiper PA-23 · S/N 23-1093N320DJJohnston Donald R LANCAIR 320 · S/N 249-320-17Registration pendingN32DQConsolidated Aeronautics LAKE LA-4-200 · S/N 855N3412EReid 3/4 BOEING P-12E · S/N AWR-01N3424VCessna 150M · S/N 15076499N3596WPiper PA-32-260 · S/N 32-492N3935QCessna 172L · S/N 17260035N400TNCirrus Design SR22 · S/N 2957N464HTextron 182T · S/N 18283120N4XDWheeler C/Wheeler K CLASSIC 2000 · S/N 090N51PWPhillips Mark A RV-6A · S/N 25539N543BDAmerican Legend AL3 · S/N AL-1117Registration pendingN5708QMooney M20C · S/N 3056N5840KBeech S35 · S/N D-7850N628DTMontaer Ltda MONTAER MC01 · S/N 024N63TBeech A36 · S/N E-703N651CBFlight Design CTSW · S/N 05-04-07N678RVChat Daniel VANS ACFT INC RV-8 · S/N 80322N727TGGarner John T VANS RV-8A · S/N 81428N735AFCessna 182Q · S/N 18265265N750SZBaker Michael J STOL CH 750 · S/N 75-8653N758EECessna R172K · S/N R1723030N7775DPiper PA-18 · S/N 18-5960N78496Piper PA-12 · S/N 12-3907N78603Cessna 172K · S/N 17257682N80630Globe GC-1B · S/N 1035N843ACirrus Design SR22 · S/N 2196N861SRProgressive Aerodyne SEAREY LSA · S/N 1121N875MCRockwell OV-10D · S/N 155470N8779GCessna 150F · S/N 15062879N889TJCirrus Design SR22 · S/N 8944N908BCBell OH-58A · S/N 7120470N914CRChris Lord ECLIPSE 10 · S/N 12165151014N92158Cessna 182N · S/N 18260068N9471CPiper PA-28R-201 · S/N 28R-7837200N963DDGolden Flyer Construoes Ltda SEAMAX M-22 · S/N 127N966CTDiamond Aircraft Ind DA20-C1 · S/N C0066
Back to Beaufort, SC