Tucson, AZ
Cancelled registrations · 1,234
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 = 'AZ' AND d.registrant_city = 'TUCSON' 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 = 'AZ' AND d.registrant_city = 'TUCSON' 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.
N537WDDouglas Trudeau DJI PHANTOM 2 VISION · S/N PH645349490N1408FCessna 172H · S/N 17254903N701TCCessna 210 · S/N 57300N9422ZDouglas B-26C · S/N 44-34328N5NXOakley John R KITFOX IV SPEEDSTER · S/N HBS-046N67034Douglas C-54 · S/N 56548N67040Douglas C54B-DC · S/N 27232N9923UGrumman American Avn. AA-1C · S/N AA1C0157N62252Ross Doyle B BOREDOM FIGHTER W 11 · S/N 54N8103RBeech 95-B55 (T42A) · S/N TC-1260N127JKKnell Jeff ASC SPIRIT · S/N 0004N34AHDouglas SUPER R4D-8 · S/N 43360N3739GConsolidated Vultee P4Y-2 · S/N 59819N49044Cessna 152 · S/N 15281118N9720ZVertol H21A · S/N 51-15260N711RFFonk THORP T-18 · S/N 514N132DFAvimech International DRAGONFLY DF1 · S/N 0001N426ABAvimech Intl DRAGONFLY DF2S · S/N 0001N213RZReddy J/Zones A EUROPA XS · S/N A213N6166Lockheed 18-56 · S/N 2322N9434LAmerican AA-5 · S/N AA5-0234N580UC3D Robotics SOLO · S/N S111A5501499N3737HErcoupe 415-C · S/N 4362N50667Aerostar International RX 8 · S/N RX8-3373N292PMCessna T210L · S/N 21059839N578DADJI INSPIRE 1 · S/N W13DCA22020643N226AVSteadidrone MAVRIK X8 · S/N 20150063MN23CZDean S Morgan DEAN COZY · S/N 108N582ZSSteadidrone MAVRIK X8 · S/N 20140030MN711BXCessna 525 · S/N 525-0299N834BBeech/Manley BEECH/MANLEY T-34B · S/N BG274MN8636ZCessna TP206C · S/N P206-0436N816DDouglas C-54E · S/N 44-9150N3162PPiper PA-23 · S/N 23-1094N4858GDestiny Powered Parachutes NEON YELLOW DESTINY · S/N 1C0266N492FMFouga CM 170 MAGISTER · S/N 492N4523WWoods James Arthur SCORPION II · S/N 1N7135ZPiper PA-25-235 · S/N 25-2953N1731XCessna T210L · S/N 21060752N715KBPiper PA-28-140 · S/N 28-26750N574AZCGS HAWK CLASSIC · S/N HSSC-425-503-TRIN555RKCessna T210L · S/N 21059997N761BPCessna T210M · S/N 21062128N50228Cessna 150H · S/N 15069150N96454Douglas C54D-DC · S/N 10864N24743Piper J3C-65 · S/N 3415N907ACCaudron 277 · S/N 7546/135N8319VPiper PA-28-161 · S/N 28-8316024N555HUBeech 95-A55 · S/N TC-464N5076WPiper PA-28 · S/N 28-85
Back to Tucson, AZ