Decatur, TX
Registered aircraft · 74
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'DECATUR' 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 = 'DECATUR' 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.
N123YPErcoupe 415-CD · S/N 4503N1243SCessna 172L · S/N 17259355N1426LBeech A23 · S/N M-820N1513CCessna 180 · S/N 30213N160SDShephard Steven W SUPER CRAFT · S/N 160N1666Struze-Volmer VJ-22 · S/N 386N177VACessna 177 · S/N 17700881N1860ABeech A36 · S/N E-1933N2048VBeech A36 · S/N E-1404N228DLCirrus Design SR22T · S/N 9042N2319JPiper PA-18-150 · S/N 18-7909101N2383HErcoupe 415-CD · S/N 3008Sale reportedN250FCessna 182B · S/N 52184N25GKSkykits SAVANNAH VGW · S/N 09-06-51-833N2666UCessna 172D · S/N 17250266Registration pendingN2837VCessna 150M · S/N 15076296N2920YCessna 182E · S/N 18253920N29BFGuyer Boredom Fighter W-11 · S/N 315N3046GAircoupe F-1A · S/N 5746Sale reportedN3417APiper PA-22 · S/N 22-1687N3420XMooney M20C · S/N 3397N3448QMaule M-6-235 · S/N 22030CN362CDCirrus Design SR22 · S/N 1392N369ERCessna 172RG · S/N 172RG0062N38WWWedlund William D SPORTSMAN VJ-22 · S/N 74555N4154ZPiper PA-18-150 · S/N 18-8333N43758Mccormick Kevin RV6 · S/N 23648N4381QCessna 172L · S/N 17260281N469DWHiller UH-12C · S/N 869N4766MBeech A36 · S/N E-1259N4844DCessna 182A · S/N 34944N48WBDJI AGRAS T100 · S/N 1581F8ZLC258K0021UEFN498DLLance Daniel D CHALLENGER II · S/N CH2-0903-2375N5299SPiper PA-28-140 · S/N 28-26744N5324XAerotek PITTS S-2B · S/N 5011N54WBDJI AGRAS T100 · S/N 1581F8ZLC2587002V8Q5N5509PPiper PA-24-250 · S/N 24-572N5611BEldon L Thompson STOL CH-701 · S/N 7-7194N6313HPiper J3C-65 · S/N 19493N6565MCessna 182P · S/N 18263758N6590SCessna 150H · S/N 15067390N6641TBeech A36TC · S/N EA-68N6759CBeech A36 · S/N E-1686N6781NMooney M20C · S/N 680089N681USchweizer SGU 2-22E · S/N 217N6837QBeech A36 · S/N E-2143N7080TCessna 172 · S/N 46680N725SVCessna 441 · S/N 441-0051N7268YCessna T206H · S/N T20608046N72804Cessna 120 · S/N 9990
Back to Decatur, TX