Austin, TX
Cancelled registrations · 608
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 = 'AUSTIN' 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 = 'AUSTIN' 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.
N311SWSkyways Air Transportation V2 · S/N 14N312SWSkyways Air Transportation V2 · S/N 13N7416BBalloon Works FIREFLY 7 · S/N F7-236N842KGreat Lakes 2T-1 · S/N 106N204TXEurocopter AS 350 B2 · S/N 3711N337SWSkyways Air Transportation V2 · S/N 11N314SWSkyways Air Transportation V2.7 · S/N 0N861PEDJI PHANTOM 4 PRO V2.0 · S/N 11UCF7JOA50823N307GPIai GULFSTREAM G150 · S/N 314N314SWSkyways Air Transportation V2.2 WNTAC · S/N 0N408KTLearjet 45 · S/N 163N108VKCessna 172S · S/N 172S8932N8149ZCessna 210-5(205) · S/N 205-0149N595SKDJI MATRICE 300 RTK · S/N 1ZNDH5G00AC8CZN8488YPiper PA-30 · S/N 30-1651N2ZQSchleicher ASW-22BLE · S/N 22074N708SWBoeing 737-7H4 · S/N 27842N777SLCessna 500 · S/N 500-0307N705AWNorth American SNJ-5C · S/N 90847N824ACAirbus Industrie A319-131 · S/N 1604N845ACAirbus Industrie A319-131 · S/N 1445N187ACBoeing 737-76N · S/N 32404N15932Embraer EMB-145EP · S/N 145.015N591SKImpossible Aerospace US-1 · S/N IAUS1-00001N6996VMooney M20F · S/N 22-1358N780CXYuneec Electric TYPHOON Q500 4K · S/N YU15230378B04B01N270TX3D Robotics SOLO · S/N S111A5501851N663ERSensefly EBEE · S/N EB-0321306N778PTDJI PHANTOM 3 ADVANCED · S/N CH052327326497N920CHDJI MAVIC AIR 2S · S/N 3YTBJ4Q00300BPN26LGGeorge Thomas J KITFOX V · S/N S9408-0045N719ZCDJI INSPIRE 1 · S/N W13DCC30030645N95130Cameron Balloons US O-84 · S/N 5595N1235UCessna 210N · S/N 21064677N498SKDJI MATRICE 600 PRO · S/N M80DFD26030050N75TKRobinson Kent A TUKAN · S/N 6001N288ACBoeing 737-86J · S/N 28068N175CSAirbus A319-132 · S/N 1955N6061RLindstrand Balloons 90A · S/N 5124N593SKDJI MATRICE 300 RTK · S/N 1ZNDH5G00ALB13N251LCDraganfly Innovations DRAGANFLYER X4-P · S/N 9E224CN406HDAscending Technologies ASCTEC FALCON 8 · S/N 31194N6678PPiper PA-24-250 · S/N 24-1802N9792RBeech M35 · S/N D-6298N125CSAirbus A319-112 · S/N 1551N88855Raytheon A36 · S/N E-3239N920CHDJI MAVIC AIR 2S · S/N 3YTSJ3Q0030LHRN499SKYuneec International H520 · S/N YU17360102B11A01N773FCHexacrafter HO-1250 · S/N FC-0003N493SKStraight UP Imaging ENDURANCE · S/N E22P334C11N006
Back to Austin, TX