Apopka, FL
Cancelled registrations · 46
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 = 'APOPKA' 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 = 'APOPKA' 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.
N743LGLearjet 60 · S/N 172N911LMCanadair CL-600-2B16 · S/N 5004N191GHRaytheon Corporate Jets HAWKER 800XP · S/N 258318N66BECessna 525 · S/N 525-0174N339ESCessna 680 · S/N 680-0339N654ANLearjet 60 · S/N 065N19SVCessna 650 · S/N 650-7002N517CRLearjet 60 · S/N 015N384TXCessna 680 · S/N 680-0110N363WCCessna 550 · S/N 550-1098N625CSSheffield Curtis A BUCCANEER II XA650 · S/N B2A-028N152AHHickox Andy ANDYS GYROPLANE · S/N 1263063-1N803LFDJI PHANTOM 2 VISION + · S/N PH645502426N996JSLearjet 31A · S/N 119N6790JPiper PA-28-140 · S/N 28-24518N4867VTaylor Vance A FIRE STAR KXP · S/N 267 42 0708N785AHCessna 650 · S/N 650-0073N9858UGrumman American Avn. AA-5A · S/N AA5A0258N83830Cowart B-8M · S/N 001N9436Tarpley B-8M · S/N 1N121JDIsrael Aircraft Industries 1124 · S/N 252N127NAFanning James F RV-9A · S/N 91270N601CKKaplan Leonard S PROTECH PT 2B · S/N PT 1052N2795ZRaven Industries RALLY RX7 · S/N RX7-413N983AGCessna 550 · S/N 550-0414N7429HPiper J3C-65 · S/N 20698N3508BBeech E35 · S/N D-3725N4404DBeech G35 · S/N D-4632N170RVVicory Richard J COMP AIR 6 · S/N 026313N570BACameron Balloons A-105 · S/N 3836N5591UPiper PA-28-140 · S/N 28-26321N6693Fausnight BENSEN B-8M · S/N 528764N777TFBeech 65-80 · S/N LD-38N3155PPounds Jerrell M-SQUARED SP 1000 · S/N 503N2276XRobinson Helicopter R22 BETA · S/N 0508N341SMDestiny 2000 · S/N 23657N60389Cessna 150J · S/N 15070275N1466QCessna 150L · S/N 15072766N9977GCessna 188A · S/N 18800777N741WBXray 78 RV-4 · S/N 262N3683EPiper PA-36-300 · S/N 367860036N4320CAeronca 7EC · S/N 7EC325N1540VBeech C35 · S/N D2886N9397EAeronca 11AC · S/N 11AC-1035N3974PPiper PA-18A 150 · S/N 18-4765N29421Adair Bi Plane AN-1 · S/N 100
Back to Apopka, FL