Gainesville, FL
Cancelled registrations · 179
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 = 'GAINESVILLE' 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 = 'GAINESVILLE' 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.
N553QAAltavian NOVA F6500 · S/N 3031N553SAAltavian NOVA F6500 · S/N 3032N6682CAltavian NOVA F6500 · S/N 3018N6682HAltavian NOVA R8400 · S/N 3002N68SPMaule M-5-220C · S/N 5019CN2LBell Helicopter Textron 206L-1 · S/N 45576N6682BAltavian NOVA F6500 · S/N 3016N33CPStringfellow James L GLASTAR · S/N 5389N63925Aero Vodochody L39C · S/N 031803N586RECessna 550 · S/N 550-0199N295PRPrioria Robotics MAVERIC MV-1030 · S/N MV100-100122N180PMMcreynolds Paul P KR-2 · S/N 5917N5266ZPiper PA-22-108 · S/N 22-8956N54114Auxier Herschel A JR SEA REY AMPHIBIAN · S/N 1DK 063N270JMMaule M-4-210C · S/N 1091CN772TD F L Holding TANGO · S/N T001N6062NNagy Wayne A BUCCANEER II · S/N BUC 2-0117N917GBeech 65-80 · S/N LD-19N41974Raven S55A · S/N S55A-948N109BXBrown Narcisse A CHRISTEN EAGLE II · S/N 0245N62110Smysor B-8M · S/N 001N168ACBell OH-58A · S/N 72-21266N4531LRembert Thomas J TERATORN TIERRA II · S/N 1N44WHCessna 172N · S/N 17272313N7746QCessna 310Q · S/N 310Q0246N689CPCessna 337A · S/N 337-0330N58ACBeech 65-90 · S/N LJ-77N48390Cessna 152 · S/N 15283330N5004CBeech B35 · S/N D-2266N4320Peck SKYHOPPER MODEL 20 · S/N DRP-1N168TTEclipse EA500 · S/N 000042N24917Piper J4A · S/N 4760N9091SBalloon Works FIREFLY 8B · S/N F8B-304N36936Balloon Works FIREFLY 7 · S/N F7-191N6314JDouglas DC-7B · S/N 45359N7397VBellanca 17-30 · S/N 30237N4923SAdams Steven Jon ROSEBUD AX4 · S/N 49A-4N98657Cessna 402B · S/N 402B1032N777ABBeech 58 · S/N TH-209N61756Cessna 172M · S/N 17264778N6444UMooney M20C · S/N 2191N4027RPiper PA-32-300 · S/N 32-40290N999DEBeech B-60 · S/N P-447N6352XCessna 402B · S/N 402B1319N200FLCessna 404 · S/N 404-0633N414NCessna 210 · S/N 57270N2606RPiper PA-28R-200 · S/N 28R-35225N5361FPiper PA-28R-200 · S/N 28R-7635458N77BBWest Paul ROTORWAY EXEC 162F · S/N 6497N64137Cessna 172M · S/N 17265042
Back to Gainesville, FL