Denton, TX
Registered aircraft · 497
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 = 'DENTON' 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 = 'DENTON' 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.
N100ECBeech B300 · S/N FL-4N101VKCessna 172S · S/N 172S8211N102NTBirdseyeview Aerobotics FIREFLY 6 PRO · S/N 6-PRO-1393N103MTEurocopter Deutschland MBB-BK 117 C-2 · S/N 9286N105NKAirbus Helicopters MBB-BK 117 C-2 · S/N 9860N1082FCessna 172N · S/N 17272950N10TTCessna P210N · S/N P21000056N1127DCessna 172S · S/N 172S10247N113MTEurocopter Deutschland EC 135 P2+ · S/N 1103N114TRLacombe Thomas D LONG EZ · S/N 101N1165UCessna 172M · S/N 17266872N119MTAirbus Helicopters Deutschland EC135 P3 · S/N 1197N12104Cessna 172M · S/N 17261812N12180Cessna 172M · S/N 17261864N121PEBeech B36TC · S/N EA-388N12240Cessna 172M · S/N 17261901N122VKCessna 172S · S/N 172S9856N1230TPiper PA-34-200 · S/N 34-7250268N12360Cessna 172M · S/N 17261947N1252HAeronca 15AC · S/N 15AC-264N125HLDiamond Aircraft Ind DA 40 · S/N 40.551N12701Cessna 172M · S/N 17262189N12820Cessna 172M · S/N 17262289N12886Cessna 172M · S/N 17262343N129FRCessna 172P · S/N 17275338N12FPAero Commander 112 · S/N 238N12KBCessna 172M · S/N 17261915N13056Cessna 172M · S/N 17262463N130AGPiper PA-44-180 · S/N 4496578N131AGPiper PA-44-180 · S/N 4496589N131MTCessna 172M · S/N 17262525N135LXEurocopter Deutschland EC 135 P2+ · S/N 1004N135UTEurocopter Deutschland EC 135 P2+ · S/N 0776N135VVEurocopter Deutschland EC 135 P2+ · S/N 1019N135WLEurocopter Deutschland EC 135 P2+ · S/N 1083N1364UCessna 172M · S/N 17267035N1369TPiper PA-34-200 · S/N 34-7250301N136UTEurocopter Deutschland EC 135 P2+ · S/N 0841N13941Cessna 172M · S/N 17263044N1417UCessna 172M · S/N 17267085N143CKGates Lear Jet 25B · S/N 143N1441JRockwell International 112A · S/N 441N144CHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9574N145WWPiper PA-44-180 · S/N 4496145N1494VCessna 172M · S/N 17263624N14NRPiper PA-28-140 · S/N 28-20614N15008Piper PA-34-200 · S/N 34-7250346N15035Piper PA-34-200 · S/N 34-7250353N1511SFirefly Balloons FIREFLY 7-15 · S/N F7-2004N152RECessna 152 · S/N 15284555
Back to Denton, TX