Lake Jackson, TX
Registered aircraft · 43
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 = 'LAKE JACKSON' 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 = 'LAKE JACKSON' 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.
N101UTCessna 172L · S/N 17259900N118VBeech V35 · S/N D-8096N132GASlingsby T67C · S/N 2086N1775PQuicksilver MXL II SPORT · S/N 000640 MXLII SPORTN1SRPiper PA-23-250 · S/N 27-2050N206KTFeatherston Les W HARMON ROCKET II · S/N 00127N2071CCrosley John M FLIGHTSTAR II SL · S/N FS241N2219DCessna 170B · S/N 20371N2285GCessna 182B · S/N 51585N235GHHunter Gary A VARIEZE · S/N 1855N3256TCessna 177 · S/N 17700556N335CDFeller Clay BLUE HERON EXPRESS · S/N 4835N3497TCessna 177 · S/N 17700797N34996Cessna 177B · S/N 17702146N3874TPiper PA-28R-180 · S/N 28R-30199N40008Piper PA-28-161 · S/N 28-7716317N4167DPiper PA-32R-301T · S/N 3257138N4176NCessna 120 · S/N 13647N4838SPiper PA-32-260 · S/N 32-1267N511CRaytheon A36 · S/N E-3576N5336NCessna 182Q · S/N 18267654N5374JCessna 172N · S/N 17273767N5986UPiper PA-28-140 · S/N 28-26872N6433UMooney M20C · S/N 2180N67993Cessna 152 · S/N 15282126N693JDCirrus Design SR22 · S/N 3021N701CWKyle A Woodfill ZENITH CH 701 · S/N 7-7715N7043PNew Kolb FIRESTAR II · S/N FS00-3-00041N708FAviat A-1C-180 · S/N 3030N711XEElkins John M SEAREY · S/N 1DK156N723SSCessna 182Q · S/N 18267193N728SCCessna T310Q · S/N 310Q0989N73AGPiper PA-20 · S/N 20-622N771GSSchuh Greg ZENAIR CH 701 STOL · S/N 7-9294First renewal noticeN8049LCessna 172H · S/N 17256249N8196WPiper PA-28-180 · S/N 28-2324N8275RBellanca 17-31A · S/N 32-84N83703Aeronca 7AC · S/N 7AC-2381N8824GCessna 150F · S/N 15062924N909ENVans RV-12 · S/N 120745N9640TCessna 210 · S/N 57440N97FEEllington Floyd Owen RANS S-6 ESXL · S/N 12961075XLN9956CStinson L-5 · S/N 04003
Back to Lake Jackson, TX