College Station, TX
Registered aircraft · 126
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 = 'COLLEGE STATION' 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 = 'COLLEGE STATION' 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.
N108PRussell William M LANCAIR 320 · S/N 309-320-71N109JMT-1 T1 FORTUNE · S/N JMAC0200TAN1101RSnark Aero SEAREY · S/N 1LK-528CN121AWWikstrom Andrew H KITFOX IV · S/N BDU154N124XAgold Todd R VANS RV10 · S/N 40362N12AMCessna 560XL · S/N 560-5676N12DSCarr Bryan RV4 · S/N 27N12FAPilatus PC-12 · S/N 117N1328SCessna 182P · S/N 18264892N13391Cessna 172M · S/N 17262723N13TKKaminski Theodore PAZMANY-PL4 · S/N TK3N16895Cessna 172S · S/N 172S10618N172RKCessna 172S · S/N 172S8082N175PGCirrus Design SR20 · S/N 1963N199JPPickett John D REVOLUTION II · S/N 6001N200ALKittleson Allen F QUICKIE Q200 · S/N 2653N204RBPiper PA-28R-201T · S/N 28R-7703149N211DWMooney M20F · S/N 690079N212BSCessna 172S · S/N 172S8243N2457TNavion NAVION G · S/N NAV42452N247MAAmerican Champion 8KCAB · S/N 932-2003N260PMPiper PA46-500TP · S/N 4697545N262QFDJI AGRAS T20P · S/N 64UBL7B0020050N2727VCessna 177RG · S/N 177RG0674N2826UCessna 172D · S/N 17250426N2905DDrew S G Discher CCK-2000 · S/N CCK-2000-0143N3076UHastedt Margaret Jean KITFOX CLASSIC IV · S/N C9708-0198N32600Piper PA-32-300 · S/N 32-7540052N3260LCessna 172H · S/N 17256160N3417UCessna 182F · S/N 18254817N34302Cessna 177B · S/N 17701757N35HAHarmony Aeronautics ARIA 1 · S/N 20200001N37DSPilatus PC-12/47E · S/N 1039N38695Piper J3C-65 · S/N 7203N3875CDJI AGRAS T40 · S/N 1581F574B238U00101JGN3973VNorth Wing APPACHIE · S/N M5446091N4273JPiper PA-28-140 · S/N 28-22633N4325JPiper PA-28-140 · S/N 28-22700N4377APiper PA-46-310P · S/N 46-8508008N446HSRobinson Helicopter R44 II · S/N 13313N48WWBeech A36 · S/N E-940N4944WRockwell International 114 · S/N 14266N4DALearjet 45 · S/N 604N50291Cessna 172M · S/N 17264199N507SMCarf Models REBEL MAX · S/N JMAC0300TAN50EGUas Global Services ANZEN EG-1250 · S/N UASGS-HL-2001N50JVVilas John R CHALLENGER II · S/N 001N5100XCessna 182T · S/N 18281063N513TSCessna 650 · S/N 650-7096N5176DNorthwing APACHE TRIKE · S/N 43250
Back to College Station, TX