Corpus Christi, TX
Registered aircraft · 238
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 = 'CORPUS CHRISTI' 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 = 'CORPUS CHRISTI' 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.
N101CKCh-7 Heli-Sport S R L CH-7 KOMPRESS · S/N K86N1048QMaule MXT-7-180A · S/N 21034CN1074SMooney M20J · S/N 24-1127N1075MCessna 177RG · S/N 177RG0295First renewal noticeN107HMPilatus PC-12/45 · S/N 248N107VAJames A Walker RV-10 · S/N 40007N10WBeech 58P · S/N TJ-448N113DASlingsby T59D KESTREL 19 · S/N 1799N11621Cessna 150L · S/N 15075575N116FLPiper PA-18-150 · S/N 18-7509029N119BTPiper PA-28-181 · S/N 2881522N124GABeech B200 · S/N BB-1039N1262JRockwell International 112A · S/N 262N128ASRaytheon B200 · S/N BB-1950N129DPCessna 310L · S/N 310L-0006N129TPPilatus PC-12/45 · S/N 629N129UAUav Factory PENGUIN C · S/N PNC0034N130UAUav Factory PENGUIN C · S/N PNC0035N131UAUav Factory PENGUIN C · S/N PNC0037N132LADiamond Aircraft Ind DA 40 NG · S/N 40.NC266N133KCHarrison P G HARMON ROCKET II · S/N 43N1341PCessna 182T · S/N 18281876N137PSDiamond Aircraft Ind DA 62 · S/N 62.C094N13SRRasmussen Steven L STARDUSTER TOO · S/N R-1N142CSLockheed P3B · S/N LC5248N143ALLiberty Aerospace LIBERTY XL-2 · S/N 0035N143CSLockheed P3B · S/N LC5243N1461JRockwell International 112A · S/N 461N147CSLockheed P3B · S/N LC-5162First renewal noticeN148CSLockheed P3B · S/N LC-5256N14NMBeech E-90 · S/N LW-35N15122Piper PA-28-140 · S/N 28-7225595N152LSTarot X6 · S/N 13932N155MCPiper PA-31T · S/N 31T-7820069N1627DJarrett Brown REV X · S/N X1053N164SARobinson Helicopter R44 · S/N 1559N172BCessna 172N · S/N 17269593N17KAAircraft Mfg & Development CH 2000 · S/N 20-0044N1811JPiper PA-28-140 · S/N 28-24239N1833FCessna 210F · S/N 21058733N184JLMooney M20E · S/N 129N187LSUas USA TEMPEST · S/N 021016-2First renewal noticeN1930DBeech C35 · S/N D-3203N193GSCessna 182N · S/N 18260442N19657Cessna 172L · S/N 17260642N200WXBeech 200 · S/N BB-680N204LSTarot X6 · S/N 13933N205LSTarot X6 · S/N 13934N209LSTarot X6 · S/N 13935N20YLIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 076
Back to Corpus Christi, TX