Stuart, FL
Cancelled registrations · 207
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 = 'FL' AND d.registrant_city = 'STUART' 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 = 'FL' AND d.registrant_city = 'STUART' 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.
N89967Cessna 152 · S/N 15282933N8404VPiper PA-34-220T · S/N 34-8133146N5371YPiper PA-23-250 · S/N 27-2444N5GDBell OH-58C · S/N 71-20369N660RAPiper PA-34-200T · S/N 34-7870354N761PUCessna 210M · S/N 21062417N5129ACessna 172 · S/N 28129N255JDDozier James L ROTEC RALLY 3 · S/N 25054N2319HBalloon Works FIREFLY 7 · S/N 7743N427TSBell Helicopter Textron Canada 427 · S/N 56066N172DCCessna 172N · S/N 17269308N9424XCessna 210A · S/N 21057724N68147Cessna 152 · S/N 15282149N4752PCessna 152 · S/N 15284809N43999Piper PA-28R-201T · S/N 28R-7703315N108PRemote Sensing VK30 · S/N 123N5987YPiper PA-23-250 · S/N 27-3161N9366SBeech B24R · S/N MC-361N1272UCessna 172M · S/N 17266967N680CJLearjet 24B · S/N 211N5282HCessna 152 · S/N 15284080N292DSPiper PA-34-220T · S/N 3433001N309RAS.O.C.A.T.A. RALLYE 150 ST · S/N 2994N51DCBell 206B · S/N 2732N901JWGrumman G-44 · S/N 1370N7931PPiper PA-24 · S/N 24-3165N7275FCessna 140 · S/N 8469N5677NRaven S55A · S/N S55A-460N704SMCessna 150M · S/N 15078838N287RRPiper PA-34-200 · S/N 34-7350287N59335Boeing A75 · S/N 75-4012N21121Cessna 182P · S/N 18261426N1810MPiper PA-30 · S/N 30-338N695DHHenry Richard C PELICAN · S/N 532N7678RCessna 182T · S/N 18281721N8306PPiper PA-34-220T · S/N 34-8333021N48LSBell 206L-3 · S/N 51206N1000WCessna 560 · S/N 560-0204N694CTRaytheon C90A · S/N LJ-1694N999XXBell 407 · S/N 53257N117LBAerospatiale AS 355F1 · S/N 5057N3546GCessna T182T · S/N T18208076N200STIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 061N421HVBeech C90A · S/N LJ-1266N901WGGulfstream American G-1159 · S/N 126N3122FCessna 310F · S/N 310-0131N25200Fricker BENSEN B-8M · S/N B-68176818N67WQRaytheon G58 · S/N TH-2143N958JBRaytheon 58 · S/N TH-1978N43SCCessna 172 · S/N 28805
Back to Stuart, FL