Lubbock, TX
Cancelled registrations · 276
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'TX' AND d.registrant_city = 'LUBBOCK' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'TX' AND d.registrant_city = 'LUBBOCK' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N9173PWalinski Carl O TEENIE TWO · S/N 0001N2379HEngineering & Research ERCOUPE 415-C · S/N 3004N64870Cessna AT-17 · S/N 4465N5127PPiper PA-24 · S/N 24-140N1758HCessna 310C · S/N 35858N50593Taylorcraft L-2M · S/N 5486N3261RCessna 411A · S/N 411-0261N772KACessna 310J · S/N 310J0039N91243Piper PA-18-150 · S/N 18-8209009N325LACessna 182P · S/N 18263608N9991PPiper PA-36-285 · S/N 36-7560107N8523SAir Tractor AT-301 · S/N 301-0135N54443Cessna T-50 · S/N 5922N54DMMiller PITTS S-1C · S/N 4088N10313Beech G18S · S/N BA-558N866SHBeech 58 · S/N TH-1083N9871XCessna 185 · S/N 185-0071N177MCCessna 182 · S/N 33261N9958PPiper PA-36-285 · S/N 36-7560069N739SSCessna 172N · S/N 17270774N5026PPiper PA-24 · S/N 24-29N2277KCessna 172H · S/N 17255929N1056XPiper PA-28-140 · S/N 28-7525270N1171DCessna 305A · S/N 22072-CN911RREurocopter DTCHLND GMBH BK117C1 · S/N 7502N8546SAir Tractor AT-301 · S/N 301-0142N86WHI R AV Bacau YAK-52 · S/N 867114N3138LCessna 310J · S/N 310J0138N503TVVan Meter Ted QUICKIE SPECIAL · S/N TV1N765MMAkers Douglas RA40 DEFIANT · S/N 162N1966SCessna 210F · S/N 210-58737N7800MCook Mark A CHINOOK PLUS 2 · S/N 02245XSN927RPPiper PA-32-300 · S/N 32-7340152N911TCMD Helicopters 500N · S/N LN093N789HPRobinson Helicopter R22 · S/N 2840N203MCWsk-Pzl Meilec PZL M18B · S/N 1Z027-12N2393YPiper PA-36-375 · S/N 36-7802019N4191DRaven S55A · S/N S55A-886N27935Raven Industries RALLY RX7 · S/N RX7-403N534DBPiper PA-28-140 · S/N 2821534N2521WBeech 24R · S/N MC-195N32185Piper PA-28-180 · S/N 28-7505034N233TKKeen Terrell W GLASAIR-KEEN · S/N 233KN3970ZPiper PA-18-150 · S/N 18-7897N78LAPiper PA-23-160 · S/N 23-2001N4103JCessna 172N · S/N 17271585N7742CBaird CHEROKEE II · S/N JB100N31648Piper PA-28-181 · S/N 287890473N1492MCessna TU206E · S/N U20601492N3537CPiper PA-31-325 · S/N 317912096
Back to Lubbock, TX