Palestine, TX
Registered aircraft · 54
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 = 'PALESTINE' 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 = 'PALESTINE' 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.
N1119QCessna E310H · S/N 310H0119N120MZCessna 120 · S/N 9226N1894BLuscombe 8F · S/N 6321N18HJCessna 550 · S/N 550-0587N200KTCassutt IIIM · S/N 178849N2105CCessna 195B · S/N 16090N222CMPilatus PC-12 · S/N 111N2425DGunderson Cleon Henry FLOATMASTER · S/N 001N29851Taylorcraft BC12-65 · S/N 2702N2LMGlobe GC-1B · S/N 2021N310RMCessna 310Q · S/N 310Q1062N333EYSocata TBM 700 · S/N 1105N3657VCessna 140 · S/N 14928N369KTJerry D Laza OH6-A (369A) · S/N JL001N400KTBritish TMK-4 · S/N PAC/W/22164N44064Taylorcraft BC12-D · S/N 9864N44JSStoops Hugh James ACRO SPORT II · S/N 4153N4629ZPiper PA-22-108 · S/N 22-8145N464GBAndrew Bink SONEX · S/N 231N4720ZXag P100 PRO 2023 · S/N 8219425S208UN5118TLundquist Hugh KITFOX 3 · S/N 753N515FVCessna 414 · S/N 414-0410N5164ZPiper PA-22-108 · S/N 22-8819N5435ZPiper PA-22-108 · S/N 22-9209N55172Boeing A75N1(PT17) · S/N 752029N58658Cessna 182P · S/N 18262212N60097Beech C24R · S/N MC-619N633BCCessna 172P · S/N 17274633N63MTBeech 23 · S/N M-97N6429ECessna 172 · S/N 46529N65228Boeing B75N1 · S/N 75-3950N6819MStinson 108-3 · S/N 108-4819N72128Cessna 140 · S/N 9295N725BBeech A35 · S/N D-1732N7511ASchweizer 269C · S/N S1685N753DMRaytheon 58 · S/N TH-2047N784CMMorganti Charles GLASAIR · S/N 626N82208Piper PA-28RT-201T · S/N 28R-8231052N84507Cessna 182P · S/N 18261881N85969Aeronca 11AC · S/N 11AC-392N86SFGame Composites GB1 GAMEBIRD · S/N 0119N87MMCessna T210 · S/N 210-63980N8927ZCessna 310G · S/N 310G-0027N8SFBellanca 8KCAB · S/N 59-73N90386Globe GC-1A · S/N 400N918BKCessna 525 · S/N 525-0419N921TBeech 35-33 · S/N CD-129N92966Cessna T206H · S/N T20609018N9323FHughes 269B · S/N 24-0025N96494Taylorcraft BC12-D · S/N 8794
Back to Palestine, TX