Lake Wales, FL
Cancelled registrations · 52
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 = 'LAKE WALES' 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 = 'LAKE WALES' 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.
N299PGWilliam Millette ADVENTURE FUNFLYER 2 · S/N 1111ATTN49TEEvans Thomas L SR GP-4 · S/N 49N824KWLeon Wacker SKYMAX · S/N 001N609GW3D Robotics SOLO · S/N S111A5500503N307RPPowrachute PC 2000 · S/N A 307POWN44102Destiny DESTINY XLT · S/N 4C0586N577CBAmmons C D/Ammons B L WARNER REVOLUTION · S/N WR 299S181N747CSHinshaw Carl F GYROCPTER-BENSON B8M · S/N 4N15QBell 206B · S/N 2235N1308PPiper PA-23 · S/N 23-348N7051CJones Jay XP 503 · S/N 453N60MAMaxair DR 532 · S/N 452N550HLPiper PA-23 · S/N 23-430N1382LFranklin Dennis F FRANKLIN F · S/N 0002FPN39842Bellanca 17-30A · S/N 73-30521N341WDouglas DC3C · S/N 13041N134DDouglas DC3 · S/N 11731N3473PPiper PA-23-160 · S/N 23-1447N7761TCessna 172A · S/N 47361N366MXMaxair DR 532 · S/N DR0366N65DFFranklin Dennis W DRIFTER XP503 · S/N DR-0365N177FAAntonio Flavio J DR-503 · S/N 177N7756ECessna 150 · S/N 17556N7523BChampion 7FC · S/N 7FC-26N4067BBellanca 17-30A · S/N 76-30811N310KDouglas DC-3A-S1C3G · S/N 4843N45860Douglas DC3C · S/N 12528N1021GDouglas C-47 · S/N 15280N3636JCessna 150G · S/N 15064936N3121KCessna 421 · S/N 421-0102N42187Piper J3C-65 · S/N 14429N179DLLockwood Phillip J D-2000 · S/N 179N431PLLockwood Phillip DR 277 · S/N 431N229JDSukhoi SU-29 · S/N 74-05N823PTCessna 172K · S/N 17258708N3275ZPiper PA-22 · S/N 22-7227N3052PPiper PA-23 · S/N 23964N84BBBarber William D FALCON XP · S/N FXP111N212SSHudson Jeffrey Alan RANS S-12 · S/N 0192156N7065XCessna 150A · S/N 15059165N7091JBell 47G-5 · S/N 25036N7373VBellanca 17-31 · S/N 32-9N78PDHess-Fleming VARI-EZE · S/N 1610N2317NCessna 140 · S/N 12557N7178XCessna 150 · S/N 15059278N35046Piper J5A · S/N 5-558N4173CStinson 108-3 · S/N 108-5173N3292NPiper J3C-65 · S/N 22488N23545Aeronca 65-C · S/N C5029N92572Piper PA-12 · S/N 12-102
Back to Lake Wales, FL