Longwood, FL
Cancelled registrations · 54
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 = 'LONGWOOD' 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 = 'LONGWOOD' 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.
N368AGGulfstream Aerospace G-IV · S/N 1087N919MBGulfstream Aerospace G-IV · S/N 1230N8838UCessna 172F · S/N 17252749N463MAGulfstream Aerospace G-IV · S/N 1108N204JKCanadair CL-600-2B16 · S/N 5015N141MRBritish Aerospace BAE 125 SERIES 800A · S/N NA0429N228MDGulfstream Aerospace G-1159A · S/N 467N718CKCessna 550 · S/N 550-0368N1602YCessna 172C · S/N 17249302N1533VCessna 172M · S/N 17263649N90MSBeech 95-B55 (T42A) · S/N TC-1098N2175VThunder Balloons AX7-77 · S/N 961N252JBLydon Patrick F SEAREY · S/N 1DK 062N829GSBenton Fred D SEAWIND 3000 · S/N 20N734SKCessna 172N · S/N 17269075N6443SCessna 150H · S/N 15067243N3054JPiper PA-34-200T · S/N 34-7970065N90244Cessna 337A · S/N 337-0257N4913BBeech C-50 · S/N CH-304N104LTVulcanair P68C · S/N 462/CN6079HPiper AEROSTAR 601P · S/N 61P07348063358N9027VHughes 269A · S/N 66-18281N41713Touchette Robert MAXIER DRIFTER · S/N 4443780N80920Lewis Larry SPARROWHAWK · S/N 0095N2871VBeech 35 · S/N D-276N7411QBalloon Works FIREFLY 8B · S/N F8B-075N4152SRaven Industries RALLY RX7 · S/N RX7-295N9428MCessna T210K · S/N 21059328N86580Bellanca 7ECA · S/N 1003-74N8086JPiper AEROSTAR 601P · S/N 61P06257963284N48692Cessna 152 · S/N 15283361N1063AAdams Balloon A55 · S/N 087N1535PBalloon Works FIREFLY 6B · S/N 10214N1002TPiper PA-22-135 · S/N 22-2347N98GTSocata TB-20 TRINIDAD · S/N 2136N89074Cessna 152 · S/N 15282619N64WWInterplane Spol.S.R.O SKYBOY · S/N 019/2001N20BVSocata TB 10 · S/N 495N3942KPiper PA-28-140 · S/N 28-23817N179GPPapp George ROTORWAY EXEC · S/N 2917N294CDCirrus Design SR20 · S/N 1181N738VZCessna 172N · S/N 17270284N87AARaven S55A · S/N S55A-179N33127Piper PA-34-200T · S/N 34-7570092N8833BBeech 65-88 · S/N LP-2N1011Roth Jerry SEA REY · S/N 1MK 142N104ESCessna 172N · S/N 17268670N92JBeech D50A · S/N DH-182N94TEJenkins Keith D CHRISTEN EAGLE II · S/N 1N275PBBalise Peter SEA REY · S/N MK011
Back to Longwood, FL