Sebring, FL
Cancelled registrations · 104
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 = 'SEBRING' 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 = 'SEBRING' 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.
N507TACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 075N470USCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 074/USN5148GJacquneaux Glen R CGS HAWK · S/N HII-C-165-503-TRIN2505WBeech B24R · S/N MC-163N4215LCessna 172G · S/N 17254284N932VGCessna 150L · S/N 15075415N221BPPayne Ben P1 · S/N G001N471USCostruzioni Aeronautiche Tecna P2010 TDI · S/N 174/USN310USCostruzioni Aeronautiche Tecna P2006T · S/N 310/USN93USCostruzioni Aeronautiche Tecna P2006T · S/N 309/USN1645TCostruzioni Aeronautiche Tecna P92 ECHO MKII · S/N 1645N575EAChristopher Lord ECLIPSE 10 · S/N 02175241014N894GCostruzioni Aeronautiche Tecna P2008 · S/N 176N896GCostruzioni Aeronautiche Tecna P2008 · S/N 178N22EKGrosu SEBRING · S/N 001N701TACostruzioni Aeronautiche Tecna ASTORE · S/N 022N7354EDJI INSPIRE 1 PRO · S/N W21ACL25020483N6059BCessna 182A · S/N 34059N2165FPiper PA-28-161 · S/N 28-7916207N379RVHeberlein Ronald VAN'S RV-9A · S/N 90965N5233KNavion NAVION B · S/N NAV-4-2133BN159XAero Commander 500-A · S/N 500A-1045-43N797AAdams Donald E DA1 · S/N 01N80KFGraham Clifford E ACRO SPORT · S/N 877N193AAdams Donald E ADAMS SPECIAL · S/N 004N429AFKovens Robert D QUICKSILVER SPORT 2S · S/N 0201N430AFKovens Bart F SPORT 2S/QUICKSILVER · S/N 0200N5626CMooney M20K · S/N 25-0737N65635Boeing N2S-3 · S/N 756813N84RHLake LA-4 · S/N 317N224RMCostruzioni Aeronautiche Tecna P2010 · S/N 031/USN5253YAerostar International S-55A · S/N S55A-3082N718ESDJI PHANTOM 4 · S/N 07DDD4E0B11190N62701Leza Lockwood SUPER DRIFTER · S/N LL-1036N244CRPiper PA-34-200T · S/N 34-7770421N160TUCostruzioni Aeronautiche Tecna P2006T · S/N 160/USN339BECostruzioni Aeronautiche Tecna P2010 · S/N 012N31FPFpna A-22 VALOR · S/N 2RDTRN37ADDisesa R Alan BENSEN B8M · S/N RAD-01N82BSHughes J W/Robinson T A PULSAR II · S/N P9701514N630HDehavilland DH104 DOVE 5A · S/N 04378N5426RCessna 172F · S/N 17252971N1479VCessna 172M · S/N 17263613N1578UCessna 207 · S/N 20700178N2377NPiper PA-38-112 · S/N 38-79A0815N49143Cessna 152 · S/N 15281162N9236XCessna 182E · S/N 18253636N26CGGipson Clifford L KITFOX II · S/N 418N922YPiper PA-30 · S/N 30-1681N6106WWalter Ted SUPER DRIFTER 912 · S/N LL1047
Back to Sebring, FL