Kissimmee, FL
Cancelled registrations · 143
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 = 'KISSIMMEE' 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 = 'KISSIMMEE' 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.
N22434Cessna T210L · S/N 21059748N935CTCirrus Design SR22 · S/N 2935N731BLCessna A188B · S/N 18802767TN733SWBeech F33A · S/N CE-1753N89872Cessna 152 · S/N 15282898N4873WDiamond Aircraft Ind DA 40 · S/N 40.FC001N22447Cessna 210L · S/N 21059752N852KTBeech F33A · S/N CE-1766N4744BCessna 152 · S/N 15283612N6559NBeech A36 · S/N E-2052N968FJCessna 150G · S/N 15066199N94122Cessna T210L · S/N 21060513N377BJPiper PA-34-220T · S/N 34-8133098N7134TCessna 172 · S/N 46734N76JCClevenger Jim B RV-8 · S/N 81204N866FNorth American P51D-20-NT · S/N 44-12866N815EYLance M Hooley JETEZ · S/N 2009-815EY-1N7090TBalloon Works FIREFLY 7B-15 · S/N F7B386N756KLDJI PHANTOM 2 VISION + · S/N PH645421639N235JBHickey John B AX3 BALLOON · S/N 3N8379XCessna 172C · S/N 17248879N748Cessna A185E · S/N 18502035N701CMFrazier J/Slacks S ZENAIR STOL CH701 · S/N 7-1282N744MDRobinson Helicopter R44 · S/N 0259N1125YPiper PA-46-310P · S/N 46-8408073N6050CCessna 162 · S/N 16200188N380MQShort Bros SHORTS SD3-60 · S/N SH3702N5093ACessna T210N · S/N 21063264N3816KTemco GC-1B · S/N 3505N980ZSCameron Balloons Z-90 · S/N 6193N31186Head Balloons AX8-105 · S/N 318N994WCMcmillan Jim MXII · S/N 000471N829LAS N I A S SE 3130 ALOUETTE II · S/N 1461N6611RCessna 172RG · S/N 172RG0213N64874Cessna 152 · S/N 15281457N6292MCessna 152 · S/N 15284656N122SEDiamond Aircraft Ind DA20-A1 · S/N 10022N259ASDemond Kent K KD H3 · S/N 1939N1385XBell 47G-4A · S/N 7543N351MCPiper PA-34-200 · S/N 34-7350314N739FXCessna 172N · S/N 17270518N225PMCessna 402B · S/N 402B0540N4954ACessna A152 · S/N A1520913N855BGBurkhart Grob G-103A TWIN II ACRO · S/N 34017-K-249N2434APiper PA-38-112 · S/N 38-78A0686N47611Piper PA-34-200T · S/N 34-7770418N67951Cessna 152 · S/N 15285314N742RAPiper PA-28-161 · S/N 2841205N95028Cessna 152 · S/N 15285839N3150YSoucy Gene SWALLOW B · S/N 782033-2
Back to Kissimmee, FL