El Campo, TX
Registered aircraft · 44
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 = 'EL CAMPO' 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 = 'EL CAMPO' 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.
N1095EBellanca 7GCBC · S/N 980-77N1705BBoeing E75 · S/N 75-5836N20533Cessna 172M · S/N 17261370N30TAN30ta CCX-2300 · S/N CCX-2300-0012N319ZDHylio AG 230 · S/N 17906100348N3207SCessna 182G · S/N 18255707N3233ERobinson Helicopter R44 II · S/N 11661N323FHHylio AG 230 · S/N 17906100347N375GTAviat A-1C-200 · S/N 3106N385YHylio HYL-150 · S/N 17906110385Sale reported, pending cancellationN386XEDJI AGRAS T50 · S/N 1581F6BUB235J00100TPN387CCDJI AGRAS T50 · S/N 1581F6BUB246Q001TPXJN393NMRobinson Helicopter R44 · S/N 0706N3997BBoeing E75 · S/N 75-5961N4402JCessna T188C · S/N T18803736TN443DTTodd Darrell M RV-4 · S/N 65N4863NBoeing A75L3 · S/N 75-5880N4865NBoeing A75L3 · S/N 75-5882N4867EDJI AGRAS T50 · S/N 1581F6BUB24A40011LB0N50HEDJI AGRAS T50 · S/N 1581F6BUB234D001014HN5124PAir Tractor AT-402B · S/N 402A-1051N520XZDJI T40 · S/N 1581F574B239600100H6N5272TAir Tractor AT-402B · S/N 402B-1469N537AHDJI AGRAS T100 · S/N 1581F82LC258K002UK2WN61815Boeing A75 · S/N 75-1083N62586Boeing A75N1(PT17) · S/N 75-4628N63916Boeing A75 · S/N 75-4990N65293Boeing B75N1 · S/N 75-1173N66470Boeing A75 · S/N 75-7607N680PBCessna 680 · S/N 680-0145N69WRStroup PITTS SPECIAL S-1 · S/N RS-1N6AWCessna 182P · S/N 18262961N750SCarl P Eldridge CH750 CRUZER · S/N C75-11966N75758Boeing B75N1 · S/N 75-1259N75847Boeing E75 · S/N 75-8081N75937Boeing B75N1 · S/N 75-7663N7873BBoeing E75N1 · S/N 75-8096N842SHRobinson Helicopter R22 BETA · S/N 3819N87115Engineering & Research 415-C · S/N 288N87HRRobinson Helicopter R44 II · S/N 11336N9090MAir Tractor AT-402B · S/N 402B-1122N9187LBellanca 7GCBC · S/N 328-72N920ASHelio H-295 · S/N 1279N9317WCessna U206 · S/N U20607018
Back to El Campo, TX