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.
N2649XCessna P206 · S/N P206-0149N278ACAmerican Champion 7ECA · S/N 1385-2001N2820BMooney M20TN · S/N 31-0099N2830LCessna 172H · S/N 17256030N311KGGrasse Alvin K RV-7 · S/N 74457N3139QCessna 182K · S/N 18258139N317DSAltenhofen Gregory Thomas RV-4 · S/N 1294N321ARGame Composites GB1 GAMEBIRD · S/N 0008N321PMCirrus Design SR22 · S/N 3827N3239ZPiper PA-22-150 · S/N 22-7185N323LUCessna 150H · S/N 15068776N324LUCessna 150H · S/N 15067538N326KDDJI AGRAS T20P · S/N 1581F574B236E0010122N345JHBeech F33A · S/N CE910N35042Piper J5A · S/N 5-554N35581Cessna 172I · S/N 17256848N3583YCessna 182F · S/N 18254483N36267Bellanca 7GCAA · S/N 269-73N363CSTextron 182T · S/N 18283163N371MHenderson Clifford S SUPER BEAR CSH-1 · S/N 001N3800PCirrus Design SR22 · S/N 1676N382SBeech 95-C55 · S/N TE-166N383TCCessna 172S · S/N 172S9383N3928LCessna 172G · S/N 17254097N3969YCessna 210D · S/N 21058469N4013UCessna 150E · S/N 15061413N4015DJI AGRAS T40 · S/N 64TBL7K002005JN404RPCessna 550 · S/N 550-0024N40940Brown Tony CORBEN JUNIOR ACE E · S/N TB-001N4163DPiper PA-32R-301T · S/N 32-57145N421FACessna 421B · S/N 421B0431N421ZMCessna 421C · S/N 421C1058N42771Ultramagic M-65Z · S/N 65/243N42AWCessna 425 · S/N 425-0136N4323HMooney M20J · S/N 24-0704N432PKBeech B300 · S/N FL30N433BBArbc Inc DBA Lindstrand 60X · S/N 5740N433TCThunder & Colt Airborne Amer COLT 69A · S/N 2220USAN43AWCessna 425 · S/N 425-0225N444CStinson 108-2 · S/N 108-3444N45096Cameron Balloons US ZL-65 · S/N 6389N451SDLearjet 45 · S/N 411N468JGReaves Joe C RV-14A · S/N 140468N46LUPiper PA-44-180 · S/N 4496415N47LUPiper PA-44-180 · S/N 4496416N50RMBell Textron Canada 505 · S/N 65206N511WSCessna 501 · S/N 501-0136N5230DCessna T206H · S/N T20608922N5231WPiper PA-28-160 · S/N 28-269N52LUTextron 172S · S/N 172S13198
Back to Longview, TX