Daytona Beach, FL
Cancelled registrations · 270
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 = 'DAYTONA BEACH' 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 = 'DAYTONA BEACH' 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.
N34PGPiper PA-34-200T · S/N 34-7570127N364ARLearjet 60 · S/N 364N717PEPiper PA-34-200 · S/N 34-7250072N911CLLargay Charles E GLASAIR RG SH-2 · S/N 537-RN5862SSeamax Aircraft Ltda SEAMAX M-22 · S/N 156N463CCPiper PA-23-250 · S/N 27-3357N73720Cessna 172N · S/N 17267625N849ERApplied Aeronautics ALBATROSS MAX UAV · S/N A00005N8772ABeech A35 · S/N D-2194N21767Cessna 172S · S/N 172S9635N5524LCessna 172S · S/N 172S11378N3237CPiper PA-23-250 · S/N 27-7954050N320STDJI PHANTOM 4 · S/N 07DDD2GV100717N699JC3D Robotics IRIS · S/N JC-01-11055N692KTTerry Ken CHRISTEN EAGLE II · S/N TERRY-0001N844ERLatitude Engineering HQ-40 · S/N 008N22302Aeronca 50-C · S/N C3049N843ERSensefly EBEE · S/N EB-03-04416N845ERDJI INSPIRE 1 · S/N W13DCG16040384N87310Engineering & Research 415-C · S/N 483N106ERPiper PA-28R-201 · S/N 2844137N533LSEmbry-Riddle Aeronautical Univ ERFC-UAS-001 · S/N 001N72015Luscombe 8A · S/N 3442N216JDQuartz Mountain Aerospace 11E · S/N 11E-1003N2576SCessna T337C · S/N 337-0876N705AHDJI PHANTOM 4 · S/N 07DJD9B0C10671N128RVHess William E RV-8 · S/N 81054N5813GCessna 150K · S/N 15071313N2810ZBellanca 8GCBC · S/N 269-78N4994TPiper PA-34-200 · S/N 34-7250193N74CKPeterson Darrell M GLASAIR SH3R · S/N 3267N401AGCanadair CL41G · S/N 2201N575SEPiper PA-28-181 · S/N 2843575N600NADouglas DC3A · S/N 3291N1020CConvair 240 · S/N 144N58ERMaule MXT-7-180A · S/N 21041CN93JFFriend Joseph J SEA REY · S/N 1DK015N1392RGrumman American Avn. AA-5 · S/N AA5-0792N71KBCessna 150K · S/N 15071401N9032GSikorsky CH34C · S/N 54-2867N7007ZSpringer Harold L AVID FLYER C · S/N 328N9032FSikorsky CH34C · S/N 54-915N502DHSikorsky S-58 · S/N 58100N503DHSikorsky S-58 · S/N 58338N9066YPiper PA-31-310 · S/N 31-95N95760Sikorsky CH-19E · S/N 130176N95762Sikorsky UH-34G · S/N 141584N95763Sikorsky UH-19D · S/N 571619N9589WPiper PA-28-140 · S/N 28-23036N3600CCessna 180 · S/N 31098
Back to Daytona Beach, FL