Sebring, FL
Cancelled registrations · 103
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.
N3777XTraviss Douglas BENSEN B-8 · S/N D-637997N9699AWilk-John MJ5 SIROCCO · S/N 58N911UBeech C-45H · S/N AF-600N8084Douglas C-47 · S/N 43-16158N7554PPiper PA-24 · S/N 24-2762N4430JPiper PA-28-140 · S/N 28-22833N61WACessna 172 · S/N 29421N137GMMacpherson Graham SEAWIND · S/N 137N8798NPiper PA-28-140 · S/N 28-25642N3305FBell H-13E · S/N 400N228JDehavilland DH104 DOVE 6A · S/N 04391N25656Douglas DC3 · S/N 4845N89897Cessna 152 · S/N 15282908N48858Cessna 152 · S/N 15281007N921JRCessna 172 · S/N 28190N2709SCessna 150G · S/N 15066609N9625JPiper PA-28-180 · S/N 28-3781N2961CStits Playboy SA3A · S/N 1006N422KFFpna A-22 VALOR · S/N 323N7607DPiper PA-22-150 · S/N 22-5309N47126Cessna 152 · S/N 15283176N78269Cessna 172K · S/N 17257550N1077ZWhittman Tailwind W-8 · S/N 125N99154Ercoupe 415-D · S/N 1777N60346Cessna 150J · S/N 15070239N7930TCessna 175A · S/N 56630N61450Hunter John R A-28 VICTOR · S/N SA-28-001N2226QHudson Jeff PHOENIX · S/N P-001N2031SLeza-Lockwood AIR-CAM · S/N AC005N2407QSpectrum SA-22 VALOR · S/N SA-22-001N11986Douglas Charles B AIR-CAM · S/N AC055N207JBBreeden Robert DRIFTER XP503 · S/N DR0207N99195Canadair T-33 · S/N T33236N2071HCarter Charles A PRO STAR PRO TEC · S/N PT1228N5384YPayne Kelsey F XP 503 · S/N DR416N3TDDoane VOLKSPLANE-2 · S/N 1941N10074Bowers FLY-BABY 1A · S/N 649N20351Cessna 172M · S/N 17261214N2873XCessna 177 · S/N 17700273N4002FCessna 172 · S/N 36902N42496Piper J3C-65 · S/N 14767N66448Consolidated Vultee BT-13A · S/N 5954N64635Boeing B75N1 · S/N 75-6507N66555Boeing N2S-5 · S/N 75-8776N3011KCulver V · S/N V-230N52296North American AT-6A · S/N 77-4341N8111HHiller UH-12 · S/N 111N8129HHiller UH-12 · S/N 129N8128HHiller UH-12 · S/N 128N95107Taylorcraft BC12-D · S/N 9507
Back to Sebring, FL