Longview, TX
Registered aircraft · 199
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 = 'LONGVIEW' 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 = 'LONGVIEW' 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.
N5301ECessna 172N · S/N 17271827N533ZA D Ashley CASSUTT · S/N 272N53LUTextron 172S · S/N 172S13200N540GCCessna 425 · S/N 425-0026N54LUTextron 172S · S/N 172S12062N557XXCirrus Design SR22T · S/N 2395N55LUTextron 172S · S/N 172S12063N560THTextron 172S · S/N 172S11668N56GGThunder & Colt Airborne Amer COLT 56A · S/N 1843USAN573CBBrown Charlie L SHA SH-2 GLASAIR · S/N 573N5768ACessna 172 · S/N 28368N578CBLush Michael ROBINSON SPECIAL · S/N 2N585BPRaytheon 390 · S/N RB-143N5911WPiper PA-28-150 · S/N 28-3042N594LJohnson Dale R LEG2 · S/N 218N5971LAmerican AA-1 · S/N AA1-0271N6008KBeech C23 · S/N M-2086N6041NCessna A185F · S/N 18504297N607DBCessna 525 · S/N 525-0269N6105UCommander 114-B · S/N 14625N61GGEnstrom Helicopter 280C · S/N 1178N621KCirrus Design SR22 · S/N 5063N623TXAmerican Legend AL18 · S/N AL-1192N6250ZFriday Greg RANS S-12XL · S/N 06950611N6256MStinson 108-3 · S/N 108-4256N62LBLindstrand Balloons 69A · S/N 5160N6306QMooney M20F · S/N 670399N6339GAerostar International RX 8 · S/N RX8-3118N633LAmerican Champion 7ECA · S/N 1414-2025N634LAmerican Champion 7ECA · S/N 1415-2025N639SPCessna 172S · S/N 172S8047N6443FAerostar International RX-7 · S/N RX7-3073N64GBBeech 35-B33 · S/N CD-768N670MWCessna 560XL · S/N 560-5511N67555Beech D17S · S/N 6876N700WPPiper PA-32-300 · S/N 32-7940085N7031XCessna 150A · S/N 15059131N707PFCessna 550 · S/N 550-0452N71063Balloon Works FIREFLY 7 · S/N F7-391N7128DAerostar International S53A · S/N S53A-3011N7141CTextron 182T · S/N 18282375N7148XCessna 150A · S/N 15059248N716GTDassault MYSTERE FALCON 900 · S/N 168N718RMMenzie Ronald J VARI EZE · S/N 1973N720TCThunder & Colt Airborne Amer AX8 105S2 · S/N 2347N730GYTextron 525 · S/N 525-1016N731SCCessna P210N · S/N P21000543N735VKCessna 182Q · S/N 18265717N74535Mooney M20B · S/N 1846N7585TCessna 172A · S/N 47185
Back to Longview, TX