Corsicana, TX
Registered aircraft · 41
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 = 'TX' AND g.registrant_city = 'CORSICANA' 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 = 'TX' AND g.registrant_city = 'CORSICANA' 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.
N13128Cessna 177B · S/N 17702400N14243Piper PA-23-250 · S/N 27-4795N150KLCessna 150M · S/N 15077428N167SRProgressive Aerodyne SEAREY LSA · S/N 1039N170PGCirrus Design SR20 · S/N 1961N238TTAmerican Legend AL3C-100 · S/N AL-1020N24055Beech C24R · S/N MC-492N259TBeech V35A · S/N D-8664N270LCIsrael Aircraft Industries 1124 · S/N 245N3160VCessna 150M · S/N 15076405N3253SCessna 182G · S/N 18255753N35NCWood Richard H VAN'S RV-8 · S/N 80300N3816VCessna 170 · S/N 18674N3854CCessna 180 · S/N 31002N39791Lake LA-4-200 · S/N 555N431PHHanson Percy M COOT-A · S/N 1N455MBeech 95-B55 (T42A) · S/N TC-975N4795DCessna 182A · S/N 34895N479BRaytheon B300 · S/N FL-338N4RQCessna 182P · S/N 18262739N5266KCessna 172P · S/N 17274037N583WCHawker Beechcraft B300 · S/N FL-785N5841KBeech S35 · S/N D-7852N587AZJohn A Stevens JR SEAREY LSX · S/N 1LK587CN60630Cessna 150J · S/N 15070461N616JHCessna A185F · S/N 18504290N7059GCessna 172K · S/N 17258759N710KLLightsey Kenneth B RV-10 · S/N 41933N771DCCessna A185F · S/N 18504205N8258TCessna 175B · S/N 17556958N839CStinson 108 · S/N 1083839Registration pending, canceledN87346Ercoupe 415-E · S/N 519N8970WPiper PA-28-235 · S/N 28-10548N8JWCessna 560XL · S/N 560-5305N9537VMooney M10 · S/N 700027N9546ACessna 170A · S/N 19107N9765RBeech M35 · S/N D-6243N980CAPiper PA-31T1 · S/N 31T-8104010N9811JCessna A150M · S/N A1500620N98719Piper J-3 · S/N 18949N98KGGwyn Kenneth R VANS RV-8 · S/N 83002
Back to Corsicana, TX