Tampa, FL
Cancelled registrations · 817
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 = 'TAMPA' 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 = 'TAMPA' 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.
N8197RBeech 95-B55 (T42A) · S/N TC-1765N1744WBeech 58 · S/N TH-272N31SPCessna 525 · S/N 5250490N109JNAgustawestland A109E · S/N 11703N36LJGates Lear Jet 36A · S/N 044N318THCessna 208B · S/N 208B2077N1810WDJI Innovations M1P MAVIC PRO · S/N 08QCE9MA0258LVN745SACirrus Design SR22 · S/N 4302N78FBTextron B200GT · S/N BY-293N78FBBeech F90 · S/N LA-231N427GWDassault FALCON 2000 · S/N 20N1328DDeweese William O VANS RV-6 · S/N 60264N925AAEmbraer Executive EMB-500 · S/N 50000296N9162RWeeks Gyrocopter BENSEN B7MC · S/N 1N14WSBeechcraft B200GT · S/N BY-187N925AATextron 525 · S/N 525-1068N594STPiper PA 46-350P · S/N 4636594N3137KCulver V · S/N V-356N394WMDJI PHANTOM 4 PRO V2.0 · S/N 11USJ39R710167N757AGBoeing 757-256 · S/N 29306N510BTCessna 510 · S/N 510-0336N115WWolfe CASSUTT 3 · S/N 101DWN68HBHawker Beechcraft 4000 · S/N RC-68N7368XHawker Beechcraft B300 · S/N FL-538N3949JCessna 150G · S/N 15065249N35HSCirrus Design SR22 · S/N 4276N188FSAirbus Helicopters AS350B2 · S/N 7863N5977GCessna 150K · S/N 15071477N629BSWin Tec Arrowmaker H-QUAD · S/N 5746N629FSWintec Arrowmaker S1000+ · S/N 6308N8066TBonney Richard A RANS S-9 CHAOS · S/N 0793128N25474Cessna 152 · S/N 15280678N38REPiper PA-31T1 · S/N 31T-8104028N241AVTyson Richmond AVENTURA II · S/N AA2A0172N67070Stinson VULTEE V-77 · S/N 77-13N2244NCessna 140 · S/N 12480N2253NCessna 120 · S/N 12489N2580MPiper PA-12 · S/N 12-1052N851LSDJI MATRICE 600 PRO · S/N 9520171N140FMRaytheon 400A · S/N RK-401N7086VRaytheon C90GT · S/N LJ-1786N105LKCirrus Design SF50 · S/N 0072N3094HHead Balloons AX7-77 · S/N 310N83RZBeech B200 · S/N BB1024N904JGRaytheon C90GT · S/N LJ-1764N461SCPiper PA-32R-300 · S/N 32R-7780057N204EZThompson James VAR EZE · S/N 001N7204XCessna 150A · S/N 15059304N112WCHawker Beechcraft 400A · S/N RK-575N587BLBRM Aero BRISTELL S-LSA · S/N 087/2014
Back to Tampa, FL