Temple, TX
Registered aircraft · 84
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 = 'TEMPLE' 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 = 'TEMPLE' 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.
N11686Bellanca 7KCAB · S/N 310-72N1308BPiper PA-23 · S/N 23-340N135USPiper PA-46-310P · S/N 46-08078N146JFHawker Beechcraft HAWKER 900XP · S/N HA-0160N164RSSmith Ron RV6A · S/N 21168N18144Cessna 150L · S/N 15073817N1878QCessna 177RG · S/N 177RG0278N2042QCessna 172M · S/N 17265453N20455Cessna 172M · S/N 17261301N2393FCessna 210E · S/N 21058593N2484GBreitigam Daniel MONSTER WING · S/N MW618001N249TDDJI AGRAS T40 · S/N 64TBL5F002004AN2511FChampion 7ECA · S/N 126N2512SCessna T337C · S/N 337-0812Registration revokedN258CMCostruzioni Aeronautiche Tecna P2010 · S/N 118/USN2794DCessna 170B · S/N 25336N305MWInterplane USA SKYBOY · S/N 031/2004N3067LRobinson Helicopter R22 BETA · S/N 4191N310KCCessna 310R · S/N 310R0697N322TBBlack Nelson Taylor F-1B ROCKET · S/N 1N333TGProgressive Aerodyne SEAREY LSA · S/N 1108N342DAAllen David L VANS RV9A · S/N 91156N3507Patton PITTS SIC · S/N 110N357VACostruzioni Aeronautiche Tecna P2006T · S/N 401/USN3608FSixchuter SR5XP · S/N SR5200071N360RBBowman Roger O JR GLASAIR SH 2F · S/N 1016N3765HHummel James M WIND WAGON · S/N 147N39979Taylorcraft BF · S/N 6638N4024YCessna 185 · S/N 1850224N417MAPiper PA 46-350P · S/N 4636415N421BMCessna 421C · S/N 421C0108N4309SBeech A36 · S/N E-682N4399BCessna 170B · S/N 26743N440MCTextron 680A · S/N 680A0388N452SKBellanca 17-30A · S/N 73-30522N4540WWalsten Wendell O TIERRA II · S/N 419-25N458MCTextron 680A · S/N 680A0187N4843Smith Miniplane DSA-1 · S/N RWW-1N4857TPiper PA-28-140 · S/N 28-7225224N5076GBatman Wilbur D AEROTRIKE SCOUT · S/N 014N5250TPiper PA-28R-200 · S/N 28R-7235206N546PCSocata TB 9 TAMPICO · S/N 1645N5506DBeech H35 · S/N D-5046N558EXTextron 208B · S/N 208B5588N5672HPiper PA-16 · S/N 16-283N5709ECessna 150 · S/N 17209N6124AQuad City Ultralight Acft CHALLENGER I · S/N CHCW 0292 148N6178ZDarrow Stephen A BUCCANEER II · S/N B2B-K027N639SRCirrus Design SR22 · S/N 2639N6489WCessna P210N · S/N P21000785
Back to Temple, TX