Lexington, SC
Registered aircraft · 45
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 = 'LEXINGTON' 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 = 'LEXINGTON' 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.
N114TPBeech V35B · S/N D-9801N116AJSchwenk J/Schwenk D DAYTONA CUB · S/N DC03N118WWVarga 2150A · S/N VAC-131-79N137ECAmerican Champion 7EC · S/N 1016-2007N1470HPiper PA-32R-300 · S/N 32R-7780162N210CXCessna T210L · S/N 210-59719N210QBeech E18S · S/N BA-291N22304Cessna 150H · S/N 15068204N2295YCessna 177 · S/N 17700095N2312LBeech 23 · S/N M-138N242BSCessna 525 · S/N 525-0230N248RESlipstream GENESIS · S/N 024N2503XTextron G58 · S/N TH-2503N275SEPilatus PC-24 · S/N 603N276SEPilatus PC-24 · S/N 613N2817HSchweizer SGS 1-35C · S/N 77N3073Curtiss JN4D · S/N 5361N323TPKohler Terry RV9A · S/N 90485N35LMDavid J Brown MONI · S/N 350TN3909SCessna 172E · S/N 17251109N39RAAvery CORBEN BABY ACE · S/N R19716AAN4464WBeech A36 · S/N E-543N52512Boeing A75L3 · S/N 75-193N5965JCessna A150L · S/N A1500265N6020MStinson 108-3 · S/N 108-4020N6088PCessna P210N · S/N P21000141N610DPIai GULFSTREAM G280 · S/N 2104N6821GCessna 150L · S/N 15072321N68808Cessna 152 · S/N 15282384N6945JPiper PA-32R-300 · S/N 32R-7680391N747MBCirrus Design SR22 · S/N 2913N754GTTemples Glenn Albert BOWERS FLY BABY · S/N X-3967-4-09N7607TCessna 172A · S/N 47207N7725SSchweizer SGS 1-26D · S/N 425N7748SSchweizer SGS 1-26D · S/N 448N79185Fairchild M-62A-4 · S/N FC180N7DBBerry B-8M · S/N 247844537N8272YBac Jet Provost P84 MK 4 · S/N XR704N83996Champion AERONCA 7AC · S/N 7AC-2683N844RLLawrence D Faes FLY BABY · S/N LF 1N9042NRepublic RC-3 · S/N 275N907GCCrenshaw George SKYSTAR KITFOX SER 5 · S/N S94110068N9186UCessna 150M · S/N 15078137N92319Franke Russell J SEAREY · S/N 1DK109N985KKCessna 150H · S/N 15068908
Back to Lexington, SC