Sherman, TX
Registered aircraft · 50
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 = 'SHERMAN' 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 = 'SHERMAN' 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.
N1084UMooney M20M · S/N 27-0201N1219EAeronca 7AC · S/N 7AC-4777N125MPPlyler Lloyd Michael PLYLER T FALCON · S/N 1N166VCurtiss Wright TRAVEL AIR 4000 · S/N 1401N1719BBoeing E75 · S/N 75-6013N1903QCessna 177RG · S/N 177RG0303N1960Mooney M20A · S/N 1620N1PPDiamond Aircraft Ind DA 42 NG · S/N 42.N201N2479EAeronca 7AC · S/N 7AC-6058N2725LCessna 172H · S/N 17255925N2762RSchweizer SGU 2-22E · S/N 175N3151XCessna 177B · S/N 17702399N3187EAeronca 11BC · S/N 11AC-1536N31PPSpinks PAPPYS PUPPY · S/N PP-1N32608Piper J5A · S/N 5-347N3619YCessna 210C · S/N 21058119N3680Hendrix STARDUSTER SA300 · S/N 1N384AMooney M-18L · S/N 45N4161Mooney M-18C · S/N 327N437WBPiper PA-32R-301T · S/N 3257287N47655Taylorcraft DCO-65 · S/N L-5418N47KABeech A36 · S/N E-530N4894EChampion 7GC · S/N 7GC-68N4MPPlyler PITTS SPECIAL S-1 · S/N 17132829N5236BMooney M20 · S/N 1099N5438DBeech H35 · S/N D-5016N555JNNorman James RV-6A · S/N 24255N560BDCessna 560XL · S/N 560-5257N5810KBeech 35-C33 · S/N CD-898N6073SBeech A36 · S/N E-776N6287KCessna 150M · S/N 15077625N6JZPiper PA32-301FT · S/N 3232003N70139Piper J3C-65 · S/N 17118N707LSLen Shorethose KITFOX S7 · S/N KA24337648N7444RPiper PA-28-140 · S/N 28-21985N7541TCessna 172A · S/N 47141N7700JPiper PA-32-260 · S/N 32-1067N77GBMason Gerald VANS RV-4 · S/N 117N78961Mooney M20C · S/N 1995N8082WPiper PA-28-180 · S/N 28-2172N8227TCessna 175B · S/N 17556927N82588Plyler Lloyd Michael PLYLER T-CUB · S/N 1N8690RSchweizer SGS 1-26B · S/N 215N892MMortensen Geryl L S-301 · S/N 301-8N9042SBeech S35 · S/N D-7964N9126QBeech V35B · S/N D-9226N941DTrunk Erving A MSP · S/N 0208N9504DPiper PA-22-160 · S/N 22-6419N95373Taylorcraft BC12-D · S/N 9773N9RZCessna 421C · S/N 421C0236
Back to Sherman, TX