Oldsmar, FL
Cancelled registrations · 193
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 = 'OLDSMAR' 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 = 'OLDSMAR' 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.
N985WSPiper PA-36-285 · S/N 36-7660076N8197VCessna 188 · S/N 188-0447N68472Cessna 152 · S/N 15282308N87376Ercoupe 415-C · S/N 549N17529Beech 58 · S/N TH-796N9715VCessna 188 · S/N 188-0165N87026Engineering & Research ERCOUPE 415-C · S/N 199N9356KPiper PA-34-200T · S/N 34-7670199N850XPiper PA-28R-201 · S/N 2844072N285SZPiper PA-32R-301T · S/N 3257228N1819WBeech 58 · S/N TH-288N738YYCessna 172N · S/N 17270353N27JRCessna 210L · S/N 21059706N600KQPiper PA-31P · S/N 31P-7300165N25602Cessna 152 · S/N 15280760N171DKKubal Dan K LANCAIR/360 · S/N 1058PN501WCBeech B90 · S/N LJ500N931RBeech 58 · S/N TH-1616N41451Piper PA-28R-200 · S/N 28R-7435185N7215GCessna 150L · S/N 15074623N401WEPiper PA-28R-201T · S/N 28R-7803328N6190BCessna 210M · S/N 21062703N6259QCessna 152 · S/N 15285212N51002Cessna 150J · S/N 15069702N310JCCessna 310R · S/N 310R0536N54088Cessna 172P · S/N 17274871N2373RCessna 182G · S/N 18255473N5478QCessna 150L · S/N 15073378N7756MRobinson Helicopter R44 II · S/N 10501N1398TPiper PA-28R-200 · S/N 28R-7235250N46140Cessna 152 · S/N 15283006N9783BCessna 172RG · S/N 172RG1033N738NLCessna 172N · S/N 17270107N9878KPiper PA-34-200T · S/N 34-7870043N515DGRobinson Helicopter R44 II · S/N 11503N58MHBeech 58 · S/N TH-609N500ADCessna 500 · S/N 5000091N24326Cessna 172R · S/N 17280867N172MNCessna 172RG · S/N 172RG0268N740JBCessna 551 · S/N 551-0359N1103WBeech 58 · S/N TH-326N83BCPiper PA-28RT-201T · S/N 28R-7931173N4905XRockwell International S-2R · S/N 2094RN151HBCessna 150M · S/N 15076260N334KCMitsubishi MU-300 · S/N A034 S.A.N9427UCessna 150M · S/N 15078375N488JBBeech B200 · S/N BB-1099N62847Beech 58 · S/N TH-1357N308TCMitsubishi MU-2B-60 · S/N 1507SAN548DPCessna 172S · S/N 172S8380
Back to Oldsmar, FL