Austin, TX
Registered aircraft · 789
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 = 'AUSTIN' 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 = 'AUSTIN' 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.
N13EACessna 152 · S/N 15279914N141ECCirrus Design SR22 · S/N 2556N145TXEurocopter Deutschland MBB-BK 117 C-2 · S/N 9166N147LShark Aero S R O SHARK 600 · S/N 147N147TXCessna TU206G · S/N U20604987N148TXCessna 182Q · S/N 18267500Registration pendingN149DEESH Darwin R ESH/VANS RV-9A · S/N 90034N150LLCessna 150M · S/N 15076617N152MMCessna 152 · S/N 15280836N15317Cirrus Design SR22T · S/N 2444N15388Piper PA-28-140 · S/N 28-7325054N1551XPiper PA-34-200T · S/N 34-7570283First renewal noticeN158JMMills Jerry S RV-8 · S/N L-23430-51AN15KMCirrus Design SR20 · S/N 2776N15LZBoeing A75N1(PT17) · S/N 755460N15TPPorter Timothy VANS RV-4 · S/N 1990N1618CGerow Dennis L GP4 · S/N 364N163UBeech 36 · S/N E-98N167SJCessna 172R · S/N 17280167N16BSCirrus Design SR20 · S/N 11372N16BTCirrus Design SR20 · S/N 9928N1708QCessna 150L · S/N 15073008N170WLVulcanair P68C · S/N 468/CN171RPBeech V35B · S/N D-10092N1727LCessna T206H · S/N T20608791First renewal noticeN172JDCessna 172M · S/N 17263844N173PBCessna 172S · S/N 172S9442N1761KLuscombe 8E · S/N 4488N1783SBest Aviation Services PHY37 · S/N H006N17RMHawker Beechcraft HAWKER 900XP · S/N HA-0069N17TSScott Terry G SEAREY LSX · S/N 1LK539CN17ZXVulcanair P68 OBSERVER 2 · S/N 433-29/OB2N18033Cessna 150L · S/N 15073748N1826VRaytheon A36 · S/N E-3086N1834SBeech A36 · S/N E-1909N185DECessna A185F · S/N 18503523N185XVCessna A185F · S/N 18503778N191TXAmerican Eurocopter AS350B3 · S/N 4841N194METextron 525C · S/N 525C0259N194SMTextron 208B · S/N 208B5546N197HBPzl-Swidnik PW-5 · S/N 1707008N197LLCirrus Design SF50 · S/N 0197N1987CCessna 170B · S/N 26132First renewal noticeN198BAIcon A5 · S/N 00080N198GGDwight Potter M24 ORION · S/N 24192326N19CXPiper PA46-500TP · S/N 4697077N19TTDJI MINI 2 · S/N 3Q4CJ3W3A3RH09N1CJCirrus Design SR22T · S/N 1941N1LKLithuanian Factory Of LAK-12 · S/N 6112N1PTBeech 300 · S/N FA131
Back to Austin, TX