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.
N488UHHughes 369A · S/N 480405N665UHHughes 369A · S/N 880665N8894EPiper PA-34-200T · S/N 347670186N6108CCessna T210N · S/N 21063803N5283PCessna 152 · S/N 15284906N25285Luscombe 8C · S/N 1192N201BLMooney M20J · S/N 241259N1JGCessna P210N · S/N P21000561N9997QLet BLANIK L-13 · S/N 026010N150TXRaven S-60A · S/N S60A185N6344ZPiper PA-25 · S/N 25454N7504TCessna 172A · S/N 17247104N29612Cessna 177 · S/N 17700991N57870Piper PA-36-300 · S/N 367760035N59693Piper PA-36-300 · S/N 367760110N2448LPiper PA-38-112 · S/N 3879A0706N69138Cessna 152 · S/N 15282508N9035NLox Charles D MONERAI · S/N 80N6185APiper PA-36-375 · S/N 36-8102020N82195Piper PA-28RT-201T · S/N 28R-8031109N7429ZPiper PA-25-235 · S/N 25-3411N7467ZPiper PA-25-235 · S/N 25-3467N9320UCessna 150M · S/N 15078270N26828Cessna 404 · S/N 404-0602N4413YPiper PA-25-235 · S/N 25-4029N2352YPiper PA-36-300 · S/N 36-8160015N57767Piper PA-36-285 · S/N 36-7660042N4070XAero Commander S2R · S/N 1914RN6191APiper PA-36-375 · S/N 36-8102023N6443YCessna T210N · S/N 210-64383N2334YPiper PA-36-300 · S/N 36-8160005N6854BCessna 441 · S/N 4410224N419CCPiper PA-28-235 · S/N 28-7610151N8696LPiper PA-25-235 · S/N 255128N4944YPiper PA-25-260 · S/N 254746N8495VRockwell International S-2R · S/N 2255RN3726EPiper PA-36-300 · S/N 36-7960056N3888EPiper PA-36-375 · S/N 36-7802035N3947EPiper PA-36-375 · S/N 36-7802067N3795EPiper PA-36-375 · S/N 36-7802004N36169Piper PA-28-181 · S/N 28-7890498N60969Cessna 150J · S/N 15070703N735CWCessna 182Q · S/N 18265328N4918XRockwell International S-2R · S/N 2112RN6554ZPiper PA-25-235 · S/N 25-2099N3414DCessna 170B · S/N 26957N4200BHelio H-391B · S/N 004N1495XPiper PA-34-200T · S/N 34-7570263N1428XPiper PA-28-180 · S/N 28-7505227N5570VBoeing A75N1 · S/N 751269
Back to Lubbock, TX