Willis, TX
Registered aircraft · 45
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 = 'WILLIS' 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 = 'WILLIS' 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.
N1023VBell 47G-2 · S/N 2021N1219PCessna 182 · S/N 18265701N152Fesenbek Gary K RV-6A · S/N 60167N18SRSocata TBM 700 · S/N 161N19374Cessna 150L · S/N 15074374N212KTCessna TP206B · S/N P206-0349N2498VCessna 140 · S/N 14767N29BVAlexander Schleicher ASW 27-18 E · S/N 29636N32128Piper PA-28-180 · S/N 28-7505028N3281DCessna 180 · S/N 32079N3358ABeech V35A · S/N D-9062N36AVBeech 58 · S/N TH-1657N36TPCessna T182T · S/N T18208387N372SCLearjet 60 · S/N 60-373N4104PPiper PA-23-160 · S/N 23-1584N4177TPiper PA-32R-301 · S/N 3246112N42460Cessna 182L · S/N 18259024N4509ZPiper PA-22-108 · S/N 22-8011N4570LSanches Ronald E HIGHLANDER · S/N JA635-07-21N45816Luscombe 8A · S/N 2343N4848SRonald E Sanches BADLANDS TRAVELER · S/N BLAKT007N4851TPiper PA-28-180 · S/N 28-7205207N5082ACessna 172 · S/N 28082N5208ACessna 310 · S/N 35408N5234RCessna 172M · S/N 17263448N5734BBeech D-45 · S/N BG-365N61110Cessna 150J · S/N 15070809N620TSTeodor Sacaciu RV-7A · S/N 74788N627CCircle Roger C JR KITFOX MODEL 2 · S/N 421N677EBOquinn Edwin B VANS RV7 · S/N 70511N70516Piper J3C-65 · S/N 17522N70RPJohn Lawrence Pulis SMYTH SIDEWINDER · S/N 1010AN7134WPiper PA-28-180 · S/N 28-933N71MJCessna 182Q · S/N 18267250N735HDCessna 182Q · S/N 18265429N737FMN419cm VANS RV10 · S/N 40882N7389WPiper PA-28-180 · S/N 28-1274N74080Grumman American Avn. AA-5B · S/N AA5B-0121N773TXXag P150 · S/N 186324P18223449025PYN7874UCessna 172F · S/N 17251874N78861Mooney M20D · S/N 253N8008YPiper PA-30 · S/N 30-1114N8031GCessna 177RG · S/N 177RG0031N86417Cessna 337D · S/N 337-1181N911HPPiper PA-28-180 · S/N 28-7505077
Back to Willis, TX