Arlington, TX
Registered aircraft · 254
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 = 'ARLINGTON' 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 = 'ARLINGTON' 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.
N10077Cessna 150L · S/N 15074773N103PLDonald F Lepek JR RV-14A · S/N 140947N105GHArbc Inc DBA Lindstrand 105A · S/N 5675N10847Cessna 150L · S/N 15075084N108JFPzl-Swidnik PW-5 · S/N 17.09.008N1115YBeech F35 · S/N D-4248N113VFFairchild Jack E RUTAN VARIEZE · S/N 2219N11414Cessna T182T · S/N T18208413N1144XPiper PA-28-180 · S/N 28-7505215N114MGRockwell International 114 · S/N 14382N1189WCessna T182T · S/N T18208699N119CSCessna T182T · S/N T18209022N11PGCessna T240 · S/N T24002043N1227CPiper PA-22-135 · S/N 22-1034N1232ECessna T182T · S/N T18208777N12675Cessna 182T · S/N 18282026N136YXCastrillo Ivan F WAIEX · S/N W0136N1425ACessna T182T · S/N T18208821N1543TCessna T182T · S/N T18208781N160JPUltramagic M-60Z · S/N 60/10N168TCCessna 182T · S/N 18281066N16JXAerobatic Aircraft Of Texas RV6 · S/N AAT6N17AXPiper PA-28RT-201T · S/N 28R-7931132N182CKCessna 182S · S/N 18280018N182PHCessna 182T · S/N 18281031N18320Beech 58 · S/N TH-849N1883QCessna 177RG · S/N 177RG0283N1957KCessna T182T · S/N T18209091N19KHCessna 182T · S/N 18282073N1TRBeechcraft B300 · S/N FL-876N201DBMooney M20J · S/N 24-0026N201QYMooney M20J · S/N 24-0357N202BCirrus Design SR22T · S/N 10730N2049PCessna T182T · S/N T18208448N2099NCessna 182T · S/N 18281333N2111SPiper PA-28R-180 · S/N 28R-31048N2121WBeech C23 · S/N M1493N2131DBeech D35 · S/N D-3476N2146CCessna T182T · S/N T18208222N2150VCessna 140 · S/N 14379N2169MCessna 182T · S/N 18281918N216BBCameron Balloons US BEAR-120 · S/N 6793N216TKeim Tom A RV-4 · S/N 1614N2180WBeech C23 · S/N M-1563N218RKCessna T240 · S/N T24002049N2196JBell 206B · S/N 3513N22147Cessna 150H · S/N 15068095N2219TCessna A185E · S/N 185-1371N2336BTemco GC-1B · S/N 3636N2351TPiper PA-38-112 · S/N 38-78A0778
Back to Arlington, TX